Show all values for a dimension

[vireshkolagimat]

Hi All,

I'm trying create pivot chart with supplier code and store name as dimension and Sales as metric.

I need to show the all the suppliers in the pivot irrespective of the sales. So whenever they select any shop, it should all the suppliers.

I've attached sample file for the reference.

Thank you.

Regards,

Viresh

[sunny_talwar]

There is not easy way to do this... one way is to generate all the missing data for each combination of SupplierCode and StoreName.... or you can look at something like this

Problem is the null after Store1.... if you try to suppress null for StoreName dimension... then you will again go back to the same problem

[vireshkolagimat]

Hi, Even i got stuck at this point.

Thank you.

[sunny_talwar]

If you don't like this, the only option is to generate the missing data with 0 value in the script