Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This is my table and I dont want to se Account that dont have a Group.
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)
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
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
Use suppress null value then it removes the blank values and only view the value which is not blank value.
Hope this helps