Not to show other data of a dimension on the table ?

[#1]

Hi,

I have a table straight. I have a dimension called "Customer Group" and inside the column I want to show data on the table only belonging to 'Trade' for insantance I dont wanna see the other rows of the "Customer Group" dimension. How can I do that? Could you please help me as soon as possible?

Many thanks in advance

Best Regards

Kezy

[alexandros17 · Accepted solution]

In your dimension Edit the following expression:

If([Customer Group]="Trade", [Customer Group], Null())

then Check the box "Suppress When Value is null"

Let me know

[fvelascog72]

Try set analysis:

sum({<Customer Group = {'Trade'}>}Sales):

[morganaaron]

Change your dimension to a calculated dimension:

If([Customer Group]='Trade', [Customer Group],) and then suppress null values.

Alternatively, use set analysis in your expressions, so e.g. Sum({<[Customer Group]={'Trade'}>}Sales), which should therefore again only return those for that given group.

[buzzy996]

try this in dimension tab,on which ever the dimension u want1

=IF(Customer Group='Customer Group1',CustomerGroup,NULL()) and supress valeusn when it's null(check the check box)

[ramoncova06]

is best to use set analysis for this so I would go with Federico solution, here is more info on set analysis

A Primer on Set Analysis

[#7]

Hi Ramon,

I tried to do it in dimension edit the formula given above but It gave me result 0 in the table customer group side. I couldnt do it work.

[#8]

Hi again Ramon,

Sorry I made it work perfectly, Thanks to all who helped me above.

Kezy

[alexandros17]

Mark the answers please ...

[#10]

Thanks alot

Worked perfect.

cheers