Hello Experts,
I want a column that shows the total value for each dimension in every row, but it only shows the total value.
Please give me any suggestion, I'm very appreciated it.
RTF data is stored at the level of Marketing Name, Memory, and Color, but a pivot table add "ID" level.
RTF = SUM(RTF)
Gen-Total = SUM( Total AGGR( SUM(RTF) , Marketing_Name, Memory ,Color ) )
Thanks in advance
Best regards,
Walakorn T.