Show all fields in a calculated dimension

[#1]

Hello,

I have a calculated dimension in a table. That dimension has about 10 types but only want to show a table 5 .

If i have no data of any of those 5 then don´t show that field and if i check the option to show all the values ​​shown me the 10 types of dimension.

How I can do to show that 5 ?

Thanks !

[jonathandienst]

If they are sortable, then you could use dimension limits and select Top 5.

[#3]

The problem is:

DIMENSION - PEOPLE

PEOPLE

A,B,C,D,E,F

PEOPLE - MONEY

A - 5

B - 6

C - 7

If D - 0 not included in my table and i want to show all the values

[tresesco]

Populate missing values in the script. And then uncheck 'Supress zero values' in the presentation tab?

[jonathandienst]

Assuming your expression is something like Sum(Money), then turn off Suppress Zero Values on the Properties | Presentation.

[MayilVahanan]

Hi

Try like this

Chart Properties -> Presentation

Uncheck the "Suppress Zero Values" checkbox.

Hope it helps

[#7]

I have unchecked this option of course.

My Calculated Dimension: if(DIMENSION='A' or DIMENSIOn='B' or DIMENSION='C',DIMENSION)

[MayilVahanan]

Hi

Could you please say your requirement in details?

You are using if(DIMENSION='A' or DIMENSIOn='B' or DIMENSION='C',DIMENSION) as Calculated Dimension, then its not possible to bring "D" in Dimension..

Instead of using, Try like this

Dimension as DIMENSION

Measure as = If(Match(DIMENSION, 'A','B','C'), YourExp, 0)

Chart Properties -> Presentation

Uncheck the "Suppress Zero Values" checkbox.