Needed Set Analysis Help

[bharatkishore]

Hi All,

I have a Brand,Month, Market fields.

And the data looks like

Apple	62105	62294	71943	88663	86000	133000	92200	80200	81200	137200	84200	82700	1061705
Ball	439900	425883	374061	614654	710641	1029830	972000	338000	1381000	827000	819000	518000	8449969
Hat	1349478.28	1358839.57	1443269.55	1607000	2038000	1593000	1387000	788000	1437000	1315000	1250000	1422000	16988587.4
Bat	94430	83226	114705	117701	265150	149450	206450	95450	158450	141450	140450	140450	1707362
Bag	390334	405257	477715	610648	544111	590036	581536	320036	489536	515886	567536	406536	5899167
Mobile	359838	323800	339661	361976	381028	380643	335433	205433	385433	447033	390433	335433	4246144
Grand Total	2696085.28	2659299.57	2821354.55	3400642	4024930	3875959	3574619	1827119	3932619	3383569	3251619	2905119	38352934.4

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

[swuehl · Accepted solution]

What are the dimensions used in your line chart?

I think you probably just need to use the TOTAL qualifier with a field list and appropriate dimensions.

In a more complex scenario, I think you probably need to use advanced aggregation rather than set analysis.

like using Target_Month and Voice_Brand as dimensions in your line chart and as expression

=Sum(Target_Impressions) / Sum(TOTAL<Target_Month> Target_Impressions)

[bharatkishore]

Thanks a lot.. Exactly what i needed..