September 12, 2016 at 8:02 am
#311
There are options in the rows (and columns) properties that allow you to show all unrelated and empty rows. These work slightly differently depending on if the listed dimensions are related and/or virtuals. That said the general idea in your example would be for you to turn off the relationship filter and the empty filter on the rows. Be careful using these options on large dimensions like product and ship to since you will get a list of everything. You can control the detail list (prod cats in your case I believe) using a user list and/or filter. With prod cats you are probably ok to just let the list happen since there are probably not a ton of prod cats. You might want to use an axis filter to remove the ‘?’ and ‘%’.