2 Replies Latest reply on Sep 21, 2018 5:49 AM by Joao Goncalves

    YTD database to Month

    Joao Goncalves

      Hello dear companions,


      I have a issue trying to deal with my database format and some information I need to show.


      I am using a sales database that comes with YTD info and one of the tables that I need to present is Current Year Month Sales vs. Last Year Month Sales, just for the selected Month(Filter).


      But as I need the monthly YTD data on the table to calculate the monthly sales I am not able to present just the selected month.



      Here an exemple of my YTD data.


      And here the monthly data that I've calculate. But my need is to show only the highlighted information.



      Thanks in advance for your help.