
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WHERE CLAUSE in an Expression
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,
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this in your chart:
Sum({<[Major Group] = {'Beer'}>}[Sales Total])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this in your chart:
Sum({<[Major Group] = {'Beer'}>}[Sales Total])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
that worked perfectly, thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Awesome

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])
