Pivot table selection

n1ef5ng1 — Mon, 01 Jul 2013 03:29:11 GMT

Hi gurus,

I have this pivot table layout as shown below,

Country	Region	Value
Malaysia	10	300
Malaysia	20	400
Malaysia	30	222
China	10	111
China	20	222
China	30	80

For additional information, for every country, it comes with a region that is attach to them. i.eMalaysia is under region 10, and China is under region 20.

User are able to select any country(not just example stated above) within reigon 10,20,30 in the world on the first column.

However when a user select Malaysia which is region 10, the value of region 10 is wrong as compare to the rest of the region.

This is because there is a need to set a different formula if user select a country with that particular region.

Is there any coding that I can say that if user select this country, show formula A, else formula B?

Thanks

topic Pivot table selection in QlikView

Pivot table selection