Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have a problem with total aggregation in dimension.Please check the attached and let help me to find the solution.
I want the total of Nb. Cust at.
Thanks
Nima, I dont think i understand. Can you ilustrate the result you want to achive?
Why do you have Nb.cust as a dimension instead of expression?
Ok,
Here is the case:
If you look at the top of the pivot table you'll see the Year and then the measures.
If I add the Nb.Cust in the expr then it'll repeated for every single year which we don't want to.
I hope explain it clearly
Thanks,
I think I understand.
What about faking the year dimension with set analysis?
Thanks Marcus,
I had done it before for my client but he did not lik the fake one. He want to have a real year on the top and the measures as the nested column.
Nima,
Maybe you could use an additional dimension with values 'Sales', 'Tons', 'Margin' (created in the script).
Then use only one expression, in which you check /match() for your measure dimension value and pick() the appropriate aggregation function.
Up to this this will just rebuild what you already have. Adding a total for the horizontal dimension Year, and using a check for secondarydimensionality() should allow you to use your NB Cust aggregation in that separate column (the reused Total column).
Could you pleae give me an example of the script?
Thanks
Hi Nima
I made two ugly solutions that might give some ideas.
Thanks for your help but I'm still missing the partial total
Example attached.
Thanks Swuehl,
That was a nice solution.
Thanks