Excel_user12321
New Member
- Joined
- Apr 19, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, I have a problem...
I want to make a pivot table with multiple items in the row section (projects, revenue-type, and 2 more), together with a filter (revenue-type). I then want to display all values (including items with no data) from the project list, in other words the first row section. I do manage do display these values, but at the same time it also displays all "revenue-types", even when I'm filtering on just one. How can I remove all of those, apart from the one I'm filtering with?
I have tried, and I have no clue what to do.
I want to make a pivot table with multiple items in the row section (projects, revenue-type, and 2 more), together with a filter (revenue-type). I then want to display all values (including items with no data) from the project list, in other words the first row section. I do manage do display these values, but at the same time it also displays all "revenue-types", even when I'm filtering on just one. How can I remove all of those, apart from the one I'm filtering with?
I have tried, and I have no clue what to do.