How to add multiple row names in pivot table

Question & Answer
, , ,
1

Hello,
I am trying to build a pivot table to show count of service appointments by location. I am able to add count of appointment as value and location name in the column. For the row, I am able to add the service name. So far so good.
I now want to add service category next to the service name. So think of this as column 1 shows service name, column 2 shows service category name, column 3 and onwards shows each of the locations.
How do I achieve this?

2

Hi @anandds

Placing nested branches in a pivot is not a problem as you can see in the screenshot below.

image
image1351×440 43.7 KB

You could use the tabular format instead of hierarchical format if you like.

Sometimes, having row names repeat is useful; but Pivot tables in QuickSight don’t have that as a property yet. There is a workaround that @robdhondt has come up with that you can use.

Hope this answers your query.

Regards,
Giri