Calculated dimension

[stabben23]

Hi,

I need help, I want to reduce values in my dimension based on another dimension.

Lets say that I have Accounts 100, 101, 102 ,200, 201, 202.

These Accounts is grouped like A=100,101, B=200,201

Now I want to show Accounts based on Group A and B.

This will gives me Account 100, 101, 200, 201 in my dimension Account.

[stabben23]

This is my table and I dont want to se Account that dont have a Group.

[giakoum · Accepted solution]

if you use only Group as a dimension and check Suppress null you will only see values with Group.

if you want to Account as Dimension, the create a calculated dimension : If(not isNull(Group), Account)

[MK_QSL]

If you have selected Group in dimension, tick Suppress when value is null..

If Group is not in your dimension....

Use below as calculated dimension

IF(Len(TRIM(Group))=0,Account

[stabben23]

Hi Ioannis,

Yes this solve my problem, I use Account as a first Dimension and Group as second. Thats why I need to "hide" null in Group filed. When I use Group as first Dimension there is no problems. I also need to suppress null.

Thanks

[its_anandrjs]

Use suppress null value then it removes the blank values and only view the value which is not blank value.

Hope this helps