Set Analysis Expression Needed

bharatkishore — Mon, 04 Jul 2016 15:36:26 GMT

Hi All,

I have a Brand,Month, Market fields.

And the data looks like

Now i have taken a line chart and i needed expression as 62105/2696085, 439900/2696085.

I have written as =(sum(Target_Impressions)/sum(TOTAL{<Target_Month=,Voice_Brand=>} Target_Impressions))

I am getting correct values when i am selecting month and Brand filters.. But i need to get the values without making any filters.

Kindly help.

Thanks,

Bharat

Re: Set Analysis Expression Needed

Anonymous — Mon, 04 Jul 2016 15:41:10 GMT

try this Expression:

=(sum(Target_Impressions)/sum(TOTAL<Target_Month,Voice_Brand> Target_Impressions))

bharatkishore — Mon, 04 Jul 2016 15:43:36 GMT

I have given but it is not working.. I am getting same values

Anonymous — Mon, 04 Jul 2016 18:20:07 GMT

can you post sample?