Display total value in a column in pivot table

[Walakorn]

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.