Display missing group items in pivot

[mikemccormick]

I'm wondering if there's a way for a Brio/Hyperion pivot table to display all group items, regardless of whether there's records that correspond to each of them.

For example, let's say I am grouping by city, and there are five cities:

-Toronto
-Tulsa
-Montreal
-Scranton
-Vancouver

But there are only records that have cities Toronto, Tulsa, or Scranton. When you do a pivot in Brio/Hyperion, Montreal and Vancouver would not show up as column headings. I want those two cities to show up as well, and have zero or null values in the data fields for them.

Hope that makes sense! Help please!

 

[Tiglet]

Assuming you are using the Excel Add-In, then turn off the suppress missing option, then those cities will show with #missing or whichever mask you have applied to missing values

Tiglet

Living on Earth is expensive, but it does include a free trip around the sun every year