Aggregation is not working in the set analysis

[alis2063]

 Hello Team,

I am struggling to achieve the below requirement using the set analysis

As per business requirement , i want to  archive the total sales irrespective of Country  in the same table ,

Here the output highlighted in bold   as below ,

I want to get total sales w.r.t business  with ignoring the count

i.e for Import Sales :200+210=410 in the first line

            Export  Sales :300+400+301=1010

For Count calculation based on business

Import :it is repeating two times in the table  then Count is 2

Export :It is repeating  3 times in he table hence count is 3

I have attached the excel as well for your better understanding also done the calculation  within excel.

[alis2063]

@sunny_talwar can you please help me on this?

[sunny_talwar · Accepted solution]

Try this

Sum(TOTAL <Region, Business> Sales)
Count(TOTAL <Region, Business> Sales)

or

Sum(TOTAL <Business> Sales)
Count(TOTAL <Business> Sales)

[killersswang]

Awesome！Sunny

so keyword total<fieldname> could be used to ignore the filter from fieldname dimension . I never know this. Is there any tech brief to unplug the use of the total keyword.

[alis2063]

Thanks for your solution