Dec 08 2021 02:15 PM
Dear Community,
I have a question about creating a pivot table in Excel:
When I insert multiple field names (names of the columns of the data table) as rows, they are always displayed depending on each other. As an example: If I have a dataset for 26 houses and in the first column is the color (red, green or blue) and in the second column is the year of construction and I create a pivot table with both properties as rows then it will display (depending on what is at the top) how many red, green or blue houses were built at which year of construction. However, what I want is for this information to be listed INDEPENDENT of each other. So just for each variable the different expressions and the number to which that applies (as it is shown in the picture!). Currently I have to create a separate pivot table for each category which makes it extremely confusing. Can someone help?
I'm using a Mac with the most current excel version.
Thanks and greetings,
Joschie
Dec 08 2021 02:25 PM
You cannot do what you want in a single pivot table.
Dec 08 2021 09:14 PM
You could do a workaround and create separate pivot tables and use GETPIVOTDATA() to fetch the values and put them in the structure you need.
Dec 09 2021 03:40 AM
Does it work on Mac ?
Dec 09 2021 04:09 AM
Dec 09 2021 04:30 AM
@Detlef Lewin , thank you. I'm not on Mac, nice to know it works now with data models.
Dec 09 2021 05:35 AM