how can I show all rows in a pivot table even if there are zeros in the data?

[#1]

Hi all,

Ive created a pivot table that has some rows that do not display if there are zeros for all the expressions.

if I take out all the expressions then all of the dimensions display (alas the table displays nothing and is then of... shall we say... limited usefulness).

as soon as I create an expression, if there are no items that meet the criteria, the row does not display.

I have created a sub tables of all the values for the dimensions, I have made sure that display all values in the dimesion tab is checked, supress zero values in the presentation tab is unchecked, and populate missing cells is checked.

Really frustrated on this one.

any Ideas?

[ashfaq_haseeb]

Hi,

Can you do that for all dimensions.

Regards

ASHFAQ

[#3]

Thanks Trey... its cool... seems like It should be a quick fix.

[#4]

oh and if I uncheck suppress null for the first dimension I get everything but in a weird place like so

[#5 · Accepted solution]

@Trey Bayne,

I figured out a way to do this... it's ugly but it works.

I added an expression:

if

(ISNULL(MB_DQ_ISSUES_4),1)

this puts a '1' in that column for every row

I minimized the column, made the text white, and made a single space the header name  the pivot looks slightly padded on the right side but I see all my rows in the right position.

Thanks for your response!  Helped the gears grind.

Cheers,

Thomas