multilevel pivot table show 2 aggregated values

[Jess Larsen1]

Hi. I want to create a multilevel pivot table that shows the sum of monthly cost (this works) but I also want to show a total count next to each product on how many users has this product before it´s expanded. 

I do NOT have performance analytics but there also has to be a way o do this without this product?

Below is a picture of the report that I have made but in the yellow field I want a total count so you know how many users has this before you expand the product. 

I hope someone can help with this as I am lost.

Best Regards

Jess

[Adam Stout]

Multilevel pivots only show a single aggregate.  With Performance Analytics, you can use a scorecard with multiple indicators on it to get something close.

[gyedwab]

Hi Jess,

With Explore Analytics you can get exactly what you're looking for:

You can try it for 30 days here -- here's a video on the setup!