Re: How to use if condition inside sum(i.e nested sum)
First of all, using aggr in expressions is very slow and hard to read. You can use TOTAL qualifier to group by dimension (e.g. Count(TOTAL <[Customer Name], Sector> [Emp ID]) See When should the Aggr() function NOT be used?
Based on you expression, I suppose you want to sum up the output of the count. But why do you need to do that? You should be able to get the result by using only the count expression. Can you provide a sample or an Excel mock-up of what are you trying to calculate?