I am trying to create a straight table which has an added row showing the subset of the top rows filtered by Geo. I am trying to show the product and its quantity sold with an additional row showing just the canadian number. I tried using a calculated dimension with if(geo='Canada', 'Canada', Product) obviously I don't get the result I expect to see.
Expected Result:
| Product | Quantity |
| A | 1 |
| B | 2 |
| C | 3 |
| Canada | 2 |
Result Obtained:
| Product | Quantity |
| A | 1 |
| B | 1 |
| C | 2 |
| Canada | 2 |
Any help is appreciated.
Thank you
Suraj
