Add a new column with total of another column in Pivot table

[Vamsi_T]

How can I make Total of  a field(Count of stores) as a new column in pivot table.

This total in pivot table should adjust according to dimensions and external filters.

Required column is Highlighted  in below figure.

Thanks in Advance.

[Anil_Babu_Samineni]

Sum(TOTAL [No of Stores]) 

or

Sum(TOTAL <Country> [No of Stores]) 

[Vamsi_T]

Hello,

Thank for your reply.

I have tried already this one, I need it in different structure.

I updated the question.

[Anil_Babu_Samineni]

Check these

count(TOTAL <Country, Product> distinct Store)

Or

count(TOTAL <Product> distinct Store)

[Brett_Bleess]

Vamsi, did Anil's latest post get you what you needed?  If so, do not forget to return to the thread and use the Accept as Solution button on the post to mark it as correct giving Anil credit for the help and to let other Community members know that it worked too.  If you are still working on things, leave an update on where you are currently.

Regards,
Brett

[Vamsi_T]

Hello,

Its not yet solved. This formula cannot generate the total value according to dimensions. Its only generating the one dimension total value based on mentioned dimension Count(TOTAL <Product> distinct Store).

I need a solution which generates the total value according to dimension steps.

Thank You