Show all values in a dimension

[#1]

Hi All,

I have a requirement to show all countries by month in a pivot with month running horizontally and country vertically. When the user changes the month, the dimension country is reduced to show only countries that have a value and everything else is a null.

I have tried setting to not suppress nulls, but this doesnt work, i have tried to show all values but this does not work

If a create a listbox and write this expression concat(DISTINCT {1}country,',') then irrespective of selections I can see all countries. This expression does not give the same output as a dimension and actually populates nothing.

So how do i get the concat string function output in a listbox to work in a dmension on a pivot table

Your help is much appreciated

Kind Regards,

Byron

[#2]

just uncheck Supress Missing Values. in the presentation tab

[er_mohit]

in presentation tab uncheck supress Zero value

hope it helps

[#4]

Thank you both for your replies. Tried the above as well and still no luck

[#5]

Use maximum columns available with u in the chart as dimensions and then check.

thts not going to help u out but atleast u will knw whts the difference its making on the expression part to get the country dimension to get eliminated.

[#6]

Thank you for your suggestion mate. Unfortunately, the model is not my own and actually helping a friend out so don't have much visibility as to what his data set looks like. If we figure it out, I will update this post for future reference.

Closing it now

Cheers,

Byron

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#8]

You are too good Gysbert !!!

Thank you very much!

Cheers,

Byron

[#9]

Hi Gysbert i'am with a similiar problem but in a chart can you take a look in my thread when possible?

Show Dimension and zeros even if no values

Thanks in advance.

[#10]

Very good - solved my problem - thanks