Forum Discussion
Dynamic Weighted Average
Hi admiralman
If you want the Totalcount calculates based on selections of "Location","Month","Model", then you can use this formula, but it will calculate Totalcount for each row.
I would suggest you to give some expected results, then I can work directly for the purpose.
Best Regards
Maggie
I added a third model to show things a little more clear. As you can see, if I select all Models then the weighting, weightedcost2, and the total are what I would expect to see. However, if you only choose two models as in the second image things go askew. The total count continues to include the Prius even though filtered out by the slicer. Thus throwing off the weighting and the weightedcost2. If you graph this you will see the same result. I would expect the totalcount1 in image two to be 21 instead of 33 when only the Challenger and Malibu are selected.
Anyone know if this is possible?