1 Reply Latest reply on Oct 18, 2016 5:07 AM by praveen p

    Bars that show first snapshot data of next month

    Shantanu Mendhekar

      Hello,

       

      We snapshot our inventory data on a daily basis in the morning, so the snapshot shows the ending inventory of the previous day. When it comes to viewing at the monthly level, the data should show ending inventory for the month, i.e., first snapshot taken the next month.


      So, my request is to find a way out to show for the month of October a single bar showing the snapshot taken on the first day of the next month at the month level. So, for October from the image below, there should only be one bar having the value 40.

       

      Your suggestions are greatly appreciated.