Changing Expressions to filter out values from calculation

[ccb-it2013]

HI there,

I need some help with making a modification to a sales report.

I need to change my expressions to remove any style with pallet=p from the calculation.

How do I this properly?

Thanks in advance.

[johnw]

If you mean eliminating rows with pallet = P:

sum({<pallet-={'P'}>} Amount)

If you mean eliminating any style for which any row of that style has pallet = P, I think this?

sum({<style*=P({1<pallet-={'P'}>})>} Amount)

Not that these are your expressions. Your expressions seem much more complicated in some cases, but it's the set expression that's important. In some cases there's no aggregation function at all. If you need the logic, use an only() expression around those expressions to add the set analysis.