How to hide total from Pivot table

[#1]

Please find the attached my requirement. In Pivot table I just wanted to hide Total of all rows except first one.

Not able to do that , please help.

Message was edited by: Vishal Patil

[#2]

Requirement is below

[avinashelite]

if you need the total for only cash Leve1 then as per my knowledge handling this in the front end would be difficult .....we need play around the script

[vinieme12 · Accepted solution]

See attached

[avinashelite]

I think your losing the Level2 data hear ? for other values except cash ?

[vinieme12]

that matches the requirement so specifically suppressed it

We can choose to show both ways

[avinashelite]

I did not checked your file sorry , I went with the data show in the image

[vinieme12]

not a prob buddy , happens with most of us

[#9]

You are correct Vineeth and Thanks for your help