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,

[avinashelite]

dis you check the attachment ?? in the previous post

[#3]

Hi,

PFA, you just have to do some changes in presentation tab.

[#4]

Could you share your QV app or let me know the expression you are using?

[tyagishaila]

Yes Avinash, I have checked but its not working.

Thanks for time,

[avinashelite]

we are not able to replicate the error can you please share your app?? or create a sample data and share with us