Forum Discussion
Matrix Running Total per Month (Example file included)
Hi, StuartSmith
Please still use the formula I provided above, but replace the ALLSELECTED function with the ALL function.Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Both, sorry for the delay in getting back to you. Both your solutions worked great on my sample data and simple report, but upon transferring your solution to my really model with more countries, etc. both your solutions had different anomilies with the data.
As an example, Belgium has 57 Laptops, Brazil has 252 & Canada has 176
ERD with your code, it shows Belgium correctly, but Brazil and Canada incorrectly (see below)...
For Belgium it shows the the correct calculation - TotalLaptops (57) - Predicted Headcount for Jan (4) = LaptopsRunning (53)
For Brazil, it shows incorrect, instead of showing the "TotalLaptops" of 252 its showing the "LaptopsRunning (-57) value, despite both using the same measure. Very odd.
And your code is show odd values, but for different countries to the above 😁
I have no idea whats going on and hopefully the above makes sense. I need to try and figure what the hell is going on 😀