To explain my problem, I use the below sample database.
I want to create a Pivot table as follows
|BRAND||Sum of DRINKS||Consumption %|
When calculating the consumption%, it should calculate based on the total consumption based on the GENDER and AGE_GROUP selection.
User should be able to filter the Pivot table from any number of BRANDs as well.
Eventhough user filter from BRAND, consumption% should needs to calculate based on the GENDER & AGE_GROUP selections only.
Can anybody help to get the Consumtion% for my requirement please.