Pivot Table

[#1]

Dear All,

I have a Pivot Table in which the plant wise sum of the amount is shown.when i select a Plant from the table it will show only the amount for that plant . But when i select the model from the table the selection should work for other reports but the table should remain as same.

Thnks in advance...

[chiru_thota · Accepted solution]

Yes .You can use Sum({1} Amount).Then it will always shows all the data and will not respond to any selections

[#3]

Thnk You... .:)