Remove Subtotals from Pivot Table

[varunamin]

Hi,

I want to hide the subtotals in Pivot Table. I want the partial sums and always fully expanded to be checked.

Want to get rid of highlighted row in red. Thanks!

[Saravanan_Desingh]

It seems to Null or Null Sting('') row for Defects. Try selecting 'Suppress When Value Is Null'

[varunamin]

Selecting 'Suppress When Value Is Null' changes the percentage calculations.

[Saravanan_Desingh]

In that case, use AGGR in your Expression to bring all possible values of Defects.

[nevilledhamsiri]

Hi! Simply what could you do is to press Ctl+G  after curser  being kept right on to the required row to be excluded & assign the colour may be white so that the row will no longer be visible.

Neville

[varunamin]

How should I use Aggr? I have 2 formulas 1) Using Count(Distinct(A))

2) (Count(DISTINCT(A))/Count(DISTINCT total <>())

Thnaks!

[varunamin]

Doing that makes all the field color to white.

[Saravanan_Desingh]

Can you try like this?

Count(Distinct(A))
Count(Aggr(A,Defects,J_Priority_Mod,[J_Onboard vs Offboard],Status))

(Count(DISTINCT(A))/Count(DISTINCT total <>())
(Count(Aggr(A,Defects,J_Priority_Mod,[J_Onboard vs Offboard],Status))
/
Count(total <> Aggr(A,Defects,J_Priority_Mod,[J_Onboard vs Offboard],Status))

[Brett_Bleess]

Did Saran's last post get you a working solution?  If so, we would greatly appreciate your returning to this thread and closing things out by using the Accept as Solution button on that post to mark it as the solution, which will give them credit for the assistance and it lets other Community Members know it worked too.  If you require further assistance, please leave an update post, and if you did something different, please consider posting what you did and then mark that post using the button.

Regards,
Brett