How to add the total value of sales to specific country field value

[Naps_230]

Hi Team,

I have some requirement in Pivot in qik sense, i receive data client  in excel.

Here we see total Sales is 1260 , so i need to put total sales value 1260 for England country. How to Achieve this in qlik sense any frontend or backend also.

source:

Countrty	Group	Sales
India	A	100
Austrilia	A	150
England	A	200
Canada	A	230
India	B	100
Austrilia	B	160
England	B	170
Canada	B	150

out put qlik sense in pivot:

Sum of Sales	Group
Countrty	A	B	(blank)	Grand Total	A	B	Total
Austrilia	150	160		310
Canada	230	150		380
England	200	170		370	1260		1260
India	100	100		200
Total			1260	1260
Grand Total	680	580	1260	2520

[rubenmarin]

Hi, Maybe with: If(Country='England', Sum(TOTAL Sales))