Forum Discussion

ShaunGibbs23's avatar
ShaunGibbs23
Frequent Visitor
3 years ago
Solved

Yearly Change Percentage on Matrix

Hi, I'm trying to add '% Change from Last Year' column onto this matrix. Is it possible to add in a column that looks at one year (e.g. 2022) then works out the percentage difference to the year prio...
Need Help
Tips and Tricks
  • Padycosmos's avatar
    Padycosmos
    3 years ago

     

Padycosmos's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago

Hope this helps

 

ShaunGibbs23's avatar
ShaunGibbs23
Frequent Visitor
3 years ago

Hi Padycosmos, my only issue with this is that it does not seem to work as the CY and PY after var do not go green like yours, or just the last letter does? I have tried putting in extar spaces but does not seem to work.

 

Thanks for your help1

  • Padycosmos's avatar
    Padycosmos
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Could you share the screenshot of the measure?