Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Gurus,
I have a Pivot Table with some complex calculations and the dimensions that I have are Material Group – Materials.
My calculations works fine at Material level, but I need that at Material Group Level, it sums the results of Materials instead of doing the calculation at Material Group level.
Any idea of I can I handle it?
Either fix your original formula to work correctly for all levels, or use some variant of aggr(), possibly with Dimensionality(), to create the appropriate formula at the higher level. Without any specifics, it's hard to suggest anything beyond a general "These are the functions you might want to use".
Can you show by way of example what you are trying to achieve??