topic Re: Sum of partial results in Pivot table in App Development

Sum of partial results in Pivot table

jorditorras — Mon, 20 Feb 2023 13:02:48 GMT

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?

Re: Sum of partial results in Pivot table

Or — Mon, 20 Feb 2023 13:11:03 GMT

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".

Re: Sum of partial results in Pivot table

vinieme12 — Wed, 22 Feb 2023 07:33:01 GMT

Can you show by way of example what you are trying to achieve??