
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Remove Subtotals from Pivot Table
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It seems to Null or Null Sting('') row for Defects. Try selecting 'Suppress When Value Is Null'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Selecting 'Suppress When Value Is Null' changes the percentage calculations.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In that case, use AGGR in your Expression to bring all possible values of Defects.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How should I use Aggr? I have 2 formulas 1) Using Count(Distinct(A))
2) (Count(DISTINCT(A))/Count(DISTINCT total <>())
Thnaks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Doing that makes all the field color to white.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
