Straight table chart with customized rows.

[#1]

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

[consenit]

Hi there.

See QVW attached.

Kind regards,

Ernesto.