I have a sheet where I link to cells in a pivot table in a data model for values, but depending on the week there may not be any inquiries to report, so there's nothing to link the sheet to. I would like the pivot to show each campus and the number of inquiries, or if there are none then show 0's for each. The sheet that is linking to this pivot is pulling inquiry counts for each campus and other information as well as a number of other ones to display all the information in a format the client prefers.
The pivot would look something like this:
Week filter
Other filters
Campus 2025 Inqs 2024 Inqs
Campus 1 0 0
Campus 2 0 0
Campus 3 0 0
etc (there are 11 campuses)
Any assistance is appreciated!
Hi David,
Right-click the Power Pivot PivotTable, choose Options, then on the Display tab, check the box for Show items with no data on rows (or if your data is in columns, check the box for Show Items with no data on columns):
Mynda