I have created the Pivot Table below and the partial screen shot below is filtered to show a single Agency. Is there a way to suppress the Subtotal rows if there is only one LOB? For example, for this Agency, there was only Personal Lines results generated for the Carrier on row 5. The data on rows 5 and 6 are exactly the same. I would like to suppress the Subtotal aggregation for any Carrier having only one LOB row. However, for the Carriers shown on rows 11-13 and 16-18, a Subtotal is desired. This is my first post, thank you in advance for your help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Table Subtotal Rows
- Thread starter Bob_Mc
- Start date
Excel Facts
Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Similar threads
- Solved
- Question
