Add Criteria in visual opposed to using a Filter

[thomas_2583]

Hi, 

I have a line chart where by I need to see the results based on a selection. I could use the filter but I want this visual to remain static and not be dependent on a filter selection. 

Dimensions - Group

Months_to_convert

Dimension - Line

=IF(MATCH(Price_Band,'Low','High'),Price_Band)

Measure

Aggr(RangeSum(Above(Count(Count_TY), 0, RowNo())),Price_Band,(Months_to_convert,(Numeric,Ascending)))

/
Aggr(count(TOTAL <Price_Band> Count_TY),Price_Band,(Months_to_convert,(Numeric,Ascending)))

What I want to include is to show this where Category_In = 'PAL'. I don't need to see this on my line chart, just need to only show results that are Category_In = 'PAL'

Any idea how to include this please?

[jwjackso]

You can use Set Analysis 

for example Count({<Category_In={'PAL'}>}Count_TY),