Remove Subtotal rows from Multilevel pivot table report

[Hareesha]

I have a requirement to remove subtotal rows from Multilevel pivot table report . Can anyone suggest me on this?Thanks for your help!

[-Andrew-]

Try this:

1. Navigate to the pivot table report

2. Select "Column" or "Row": In the report settings, select the column or row where you want to remove the subtotal rows

3. Expand the "Advanced" section: Scroll down to the bottom of the settings page and expand the "Advanced" section

4. Remove the "Aggregation" function: Under the "Advanced" section, you will see an "Aggregation" function that is used to calculate the subtotal rows. To remove the subtotal rows, simply remove the aggregation function from the column or row you selected in step 3

5. Save the report

[Hareesha]

Hi Andrew,

Thanks for your reply, Can you please provide screenshot where i can find Advanced section. As i have searched everything in reports and i am unable to find it.

[Hareesha]

Hi Andrew,

Thanks for your reply, Can you please provide screenshot where i can find Advanced section. As i have searched everything in reports and i am unable to find it.

[Caio Miranda]

Hi @Hareesha ,

Regarding @-Andrew- post,
I think he's using the Analytics Center/Visualisation Designer to create his pivot tables, 

The kb below shows an item under "Group By" that seems to do what we want but not from the standard report screen:

Extracted from the KB:

Show row sub total

When you have a hierarchy of more than one field in the rows, this option shows the sub total of fields higher up the hierarchy

https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/reference/config-dv...

I'm on the same boat as you and have not found a solution yet, like you I'm trying to remove subtotal via the report creator but could not find a way at all. I'll update this post if I find a way to achieve this on the report creator.