Thank you for your repsonse. Your formula works for a chart straight table (by this i mean the total is correct). However , with the pivot table, the total is incorrect. Below is a result which i export to excel.
How do you make the formula work for a pivot table .
I cannot upload my QV model as it is too big and also sensitive information. What i may be able to do create a sample of the model.