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.

       

      YTD_Duvida.png

      Here an exemple of my YTD data.

      Mes_Duvida.png

      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.