Forum Discussion

eduardosilvin3's avatar
eduardosilvin3
Icon for Helper II rankHelper II
2 years ago
Solved

modify total in matrix

Hello all, I want to replicate the image in the excel in my matrix, I already have some values in the second levels of each '+' row, so the total is "Total = 19" if we take as example what PBI do. Bu...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

pls try this

  • eduardosilvin3's avatar
    eduardosilvin3
    Icon for Helper II rankHelper II
    2 years ago

    Thanks for the response, I am not sure how to get the result with that function... in the image you sent, where says "Total" I need to say "X", and where says "X" in your image I need to say -64 (1-54-11). The calculation of Revenue minus SG&A minus FX

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      2 years ago

      ok? pls try this

      • eduardosilvin3's avatar
        eduardosilvin3
        Icon for Helper II rankHelper II
        2 years ago

        Awesome I adapted to my report and works perfect.

         

        Thanks