Matrix totals wrong . . PLEASE HELP

[sdmikejr]

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 I doing wrong?

Rev | a/p % = DIVIDE([Total Rev],[Rev | plan])

Rev | a/p $ = if(isblank([Rev | a/p %]),0,[Total Rev]-[Rev | plan])

Rev |fc/p% = DIVIDE([Rev | fc],[Rev | plan])

[Anonymous]

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).