WHERE CLAUSE in an Expression

[evansabres]

Hello -

I would like to create a chart (probably a stacked column) with the total for three separate groups.

I have a dimension [Major Group] that has several items within that dimension (Food, Beer, Wine) My other dimension is called [Sales Total]

I would like to either do an expression such as [Sales Total] Where([Major Group=Beer]) either in my script or in the chart, but I can't seem to get the correct syntax.

Thank you,

[sunny_talwar · Accepted solution]

May be this in your chart:

Sum({<[Major Group] = {'Beer'}>}[Sales Total])

[evansabres]

that worked perfectly, thank you

[sunny_talwar]

Awesome

[hutchs]

This has half fixed my problem. 

I would like to display data where two conditions are met.

Type = EQUIPMENT or ACCESSORY

I can get it to work with one, and have tried various strings to add the other parameter but cannot get it to work.

So far this works.

Sum({<[Type]={'EQUIPMENT'}> } [order_val])