Pivot table subtotal issue

[swathimgumte]

@hi Folks,

I want the subtotals of the pivot table to be shown only if the values in the dimension row is more then one,

if only one row is there then the sub total row should show.

for eg( refer the image attached) i want to show total row if i have both ICATM & USI in second column.

if i have either of the one then the subtotal column should not show.

Message was edited by: swathii gumte Added sample qwv @SunnyTalwar

Message was edited by: swathii gumte Updated sample doc with reduced data

[swathimgumte]

You did it sunny...!

its working perfect as per the requirement.

Thanks a lot...