Forum Discussion
Matrix with different level
Hi, Need your kind support with the following: I have the following dataset, https://drive.google.com/file/d/1jI-B_Hmk-pLHH-UpLfk6ZC7r1IcAir-g/view?usp=share_link And I want to have a m...
Sorry Bifinity_75 but it didn't work. The value displayed is still the average. Even the subtotal is now the average of all values. So, I am a step backward:(
Values of country should be average in continent1 + average in continent2
Bifinity_75 the value of city1 displayed should be (47.92 + 19.03) and value of city2 should be (83.58+16.63)
value of country should be city1+city2