0 Replies Latest reply on Jan 9, 2014 4:19 PM by Harley Ellenberger

    Percent of total of dimension member in blended data

    Harley Ellenberger

      I have 2 data sources that are blended on a common dimension.

       

      In my 'Advertiser Totals' sheet i'm showing total spending by each of my advertisers.

       

      In my 'Grid' sheet I'm showing total spending on a particular attribute for each advertiser.  On this sheet, it's not valid to sum the rows to get a grand total.

       

      On the 'Grid' sheet, what i'd like to do is show a percentage of the total advertiser spend for each advertiser/attribute combo.

       

      For example, the "Dawn/Comparison: General" value would be 62.5% (which is $146,536/$234,369).

       

      Is there a calculated field that will allow me to do this?