Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have created one pivot table taken Operating Unit, Month, year, Group as dimension and rest in expression I want to do total for all Expression for all group something like this attached below.
I have tried show partial sum in presentation tab based on Group dimension but it doesn't show the expected result.
Thanks in Advance.
Using a partial sum should get you a result like shown in the image.
What do you get instead? (And what's the expected result if that's not shown in the attached image)?
What is the expression you are using? Are there if statement in it? May be you need Aggr() function to make this work
Sum(Aggr(YourExpression, [Operating Unit], Month, Year, Group))