This expression only works with one dimension.
Count({<[Consumer Type]={'Guest'}>}distinct[Product Type])
However I want to count the quantities of two different dimensions in the same table to look like this…
Priority Items | Quantity |
Drink | 7 |
Food | 5 |
Cioppino | 2 |
Here is my data
Purch No | Consumer Type | Product Name | Product Type |
00020 | Employee | Negroni | Drink |
00019 | Guest | Daiquiri | Drink |
00018 | Employee | Martini | Drink |
00017 | Employee | French 75 | Drink |
00016 | Guest | Mint Julep | Drink |
00015 | Employee | Sidecar | Drink |
00014 | Guest | Sidecar | Drink |
00013 | Guest | Pimm's Cup | Drink |
00012 | Employee | Gimlet | Drink |
00011 | Guest | Mimosa | Drink |
00010 | Guest | Mimosa | Drink |
00009 | Employee | Whiskey Sour | Drink |
00008 | Guest | Manhattan | Drink |
00007 | Guest | Cheeseburger | Food |
00006 | Guest | Reuben | Food |
00005 | Employee | Po'boy | Food |
00004 | Guest | BLT | Food |
00003 | Employee | BLT | Food |
00002 | Guest | Cioppino | Food |
00001 | Guest | Cioppino | Food |
