Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Financial Report

Hello,   I'm trying to build a financial report that looks like the picture. Until now I have managed to, build the 17 columns that have to do with the current year 2020. (months,quarters and 12-mo...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Fun fact I saw that video before making this post.

     

    My dashboard is more complicated so it didn't help me 😕

     

    Thanks a lot tho!

    • MattAllington's avatar
      MattAllington
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Ok, what do you mean you have built the columns for 2020. How did you build them?  What is different to these and the others you need?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I made a matrix visualization, I entered with hierarchy the accounts and subaccounts in the rows and then from a date table I added as columns the months and quarters, so every column that has to do with 2020 is done. (months,quarters,totals)

         

        The problem is that I need on the same dashboard some more columns

         

        1) difference between the current and previous month

        2) diffenence between current (2020) and same month 2019

        3) cumulative same month 2019

        4) ONLY quarters for the 2019

         

        Let me know if you need more explanations 🙂 Thanks