Forum Discussion
Matrix totals wrong . . PLEASE HELP
I am going agg trying to figure this out and am running out of time to hit deadline. I have a matrix that has 3 measures as shown below: My totals are obviously not correct. What am...
You would need to think about what you "want" to happen. Realize the totals are nothing more/less than evaluating your measures WITHOUT a filter on Fiscal Quarter. It's not like it is somehow using the rows above it to build a sum or average or whatever.
36.05% is "correct" in that it is [Total Rev] / [Rev | Plan] ... completely ignoring Fiscal Quarter. (You probably have a PLAN for Q2, but not Revenue yet... so the % looks small).