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?

[vinieme12]

See attached updated app, just add Set Analysis

[tresesco · Accepted solution]

Check attached qvw.

I have included set analysis section {<Type={'Non-Blue Box'}>} in all aggregation functions you used both in variables and direct expressions.