How to customize Multilevel pivot tables

[Justin90]

Hi,

I'm having problem with "Multilevel pivot tables". How can I create Multilevel pivot tables like this: 

The requirement is to summarize the number of incidents by category of the months.

Has anyone ever done something like that?

[Community Alums · Accepted solution]

Hi @Duong ,

You can cerate a Report using a Multilevel pivot table:https://docs.servicenow.com/bundle/sandiego-now-intelligence/page/use/reporting/concept/c_Multilevel...

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Justin90]

I tried it but how can i display both Count and Average columns?

Thanks.

[Community Alums]

Aggegation field under "Configure" tab decides that:

Aggregation

Mathematical calculation to perform on the data. The default is Count, which shows the number of records selected. To show only unique records, select Count Distinct. Select Average, Sum, or Count Distinct, to show a list of fields from the selected Table. Select a field to Aggregate by from this list. For more information on aggregation options, see Aggregation in reporting. If you choose Average, Sum, or Count Distinct, you may further be able to aggregate on fields from extended tables. See How to report on extended tables. For information about aggregating on FX currency values, see FX Currency values in reporting. Note: For duration values, you cannot customize the unit of measurement shown in the aggregation axis.