show all dimension values

[tyagishaila]

Hi All,

I have some stores which are yet to open, that's why in sale table we have no data against that store.

But when we create chart we need to show all stores, for those store which are yet to open sale can be '0' or '-'.

My problem is that , My pivot table is not showing those stores for which no sale happen.

Please help me, how can I show all stores.

Thanks,

[Kushal_Chawda]

Go to Pivot table properties -> Presentation Tab-> Uncheck suppress zero- values

[tyagishaila]

Thanks for quick reply,

I have done it, I have also checked Show All Values for dimension

Problem is, expressions don't have Zero value,

these stores are not open, So sale table has no data against these stores.

[Kushal_Chawda]

what is the expression you are using?

Try below expression and then do the setting as I suggested before

if(isnull(sum(sales)) ,0,sum(sales))

Also uncheck suppress null values for dimension

[tyagishaila]

Sorry,

I have done it also.

but problem still same.

[antoniotiman]

Try

Alt(Sum(Sales),0)

[#7]

I feel there is some other problem which is causing this otherwise unchecking 'Supress Zero-Values' should work.  Please upload sample QVW and data.

Regards,

KKR

[avinashelite]

try like this:

Go to>presentation tab> uncheck populating missing > and un check the suppress missing this should help you in getting the values .

please find the attached sample

[tyagishaila]

Thanks MANCINI,

Alt() also not useful for me, What Alt() does.

[antoniotiman]

Alt(x,y)

If x espression is valid expression (e.g. non null) returns x, else y

Regards