How to display subtotals for a main and sub category of a PivotTable?

I have the following data:

I want to calculate the occurrence of each color for a given shape.

Using PivotTables, I got this:

However, this is the output I want:

How do I achieve this in Excel? Is this possible using a PivotTable?

Thanks!

Answers


Solution: Yes, it is.

(1) Structure your selected fields like this:

(2) Right click "Shape" in Row Labels and in the "Layout & Print" tab, select "Show item labels in tabular form".

Result:


Need Your Help

maintaining a PIP repository

python git ubuntu

I am currently working on a system that requires a python installation without an internet connection available (or at least I can't assume that there is an internet connection available),

Configure & Use Broker API in .Net Project

.net tridion tridion-content-delivery

Can someone point me to documentation for setting up the Broker API to use from a .Net app? I've reviewed the documentation on livecontent, but I don't see anything specific on setting up &