filter dimension

[raadwiptec]

Hi all,

I need to filter a dimension

For ex: Customer Id is the dimension

On the Chart I need to show only Customer Ids with 200 ,250,300,450

rest should not be shown and should be hided ..it is a pivot chart and customer id is on the horizontal line

[MK_QSL]

You can use Set Analysis for that

Something like below

Dimension

[Customer Id]

Expression

SUM({<[Customer Id] = {'200','250','300','450'}>}Sales)

[raadwiptec]

it is a dimension ..not an expression ..

[#4]

Hi ,

You can use if(match(Customer Id,200 ,250,300,450),Customer Id) in dimension and suppress the nulls in the dimension

Regards

[MK_QSL · Accepted solution]

I have given expression which is limiting dimension...

If you don't want to use set analysis in expression, use below as calculated dimension in dimension tab

IF(Match([Customer Id],'200','250','300','450'),[Customer Id])

Tick suppress when value is null in dimension tab for this dimension

[vardhancse]

in expression if we restrict the dimension values, then we will see only given dimension values

[MK_QSL]

This is what your question is about..

Chart I need to show only Customer Ids with 200 ,250,300,450

rest should not be shown and should be hided

[raadwiptec]

yes manish this is good

[MK_QSL]

if problem solved... pls close the thread.. THNX

[avinashelite]

try like this

in the dimension

if([Customer Id]=200 or [Customer Id]=250 or [Customer Id]=300 or [Customer Id]=450,[Customer Id])

Supress null in the dimension

or

ADD the [Customer Id] as the dimension and in the expression

SUM({<[Customer Id] = {'200','250','300','450'}>}Amount)