topic Re: Aggregation is not working in the set analysis in App Development

Aggregation is not working in the set analysis

alis2063 — Sat, 26 Jun 2021 16:23:58 GMT

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.

Re: Aggregation is not working in the set analysis

alis2063 — Sat, 26 Jun 2021 18:04:55 GMT

@sunny_talwar can you please help me on this?

Re: Aggregation is not working in the set analysis

sunny_talwar — Mon, 28 Jun 2021 18:08:18 GMT

Try this

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

Re: Aggregation is not working in the set analysis

killersswang — Thu, 26 Aug 2021 03:43:14 GMT

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.

Re: Aggregation is not working in the set analysis

alis2063 — Thu, 24 Feb 2022 12:21:11 GMT

Thanks for your solution