Show All Dimensions

[#1]

I'm sure there is an easy way to do this but I just can't work it out.

I have a table of Sales Reps and a table of their Orders that have come in over night.

I want to show a pivot table with ALL of the reps and show the number of orders and $$ they done INCLUDING zeros.

How to do this?

[#2]

Hello rjurd,

if you want to show nullvalues within a dimension:

check chart props --> dim tab --> settings for selected dim --> show all values

if you want to show nulls in an expression:

uncheck chart props --> presentation tab --> suppress zero values (lower left hand side)

HtH

Roland