Calculation condition in a pivot table

[khaycock]

I really need to restrict a pivot table to only show data from a specific data set.

I have tired using this expression in the Calculation Condition box but it isn't restricting.

=if(Type='Non-Blue Box',1,0)

When I select the option myself manually through a list box, it does restrict.

Any ideas?

[Anil_Babu_Samineni]

May be try this?

Pick(Match(Type, 'Non-Blue Box'),1,0)

[jonathandienst]

I assume that Type is a field that has more than one possible value. [Type] will evaluate to null unless you restrict it to one possible value. To see if 'Non-Blue Box' is a possible value for Type, you can do something like

=Index(Concat(Type, ','), 'Non-Blue Box') > 0

[khaycock]

No change

[Anil_Babu_Samineni]

Can you share sample data and tell us where you are doing and what you indeed

[khaycock]

It actually is one value as I created the field in the script to only restrict this table. I tried this statement anyway and still was no change

[jonathandienst]

Then I don't fully understand your environment. If Type a field or value? Does it have a single possible value? The more information you provide, the more accurate will be the answers.

[khaycock]

Here is a sample. Only week 8 data should be shown as that is the only Non-Blue Box data I have.

Thanks

[khaycock]

I have attached a sample file above which may be of help

[vinieme12]

You need to restrict the data in Set Analysis or using Calculated Dimension

Example using Set Analysis of the Expressions

SUM({<type={'Non-Blue Box'}>}   SALES)

Example using calculated dimensions

AGGR(if(type='Non-Blue Box',Fieldname),Fieldname)