Forum Discussion
Total Average with Filter Context
Hi, I´m having problems to calculate a total average when I use filter context. I have this TABLE 1 : I need to group X and Y, because they are the same ml Model, so i ve created the ML GROUPED ...
Hi amitchandak, thank you for the answer. I tried your solution but i´m still getting a mistake.
For example the first row which has 1,88% for AVG SALES/CALLS is calculated as
(3,59% + 0,17%)/2 = 1,88% Which the AVG SALES/CALLS for model X and model Y