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