2 Replies Latest reply on Apr 16, 2019 11:56 AM by Jenna Gravley

    Cumulative verses monthly totals

    Jenna Gravley

      I have a data set that is categorized by "cumulative" and "monthly" data (see Reporttype below). I want to show the monthly data per month, but only the cumulative data by the last month. I have searched around and tried various solutions but nothing is working correctly.

       

      Here is what the data looks like, for the cumulative I only want the last month to display:

       

       

      When I try to date trunk, it also removes the months from the "monthly" category. This also happens when I "hide" the extra months in the "cumulative" category.

       

      Any help is greatly appreciated!

       

      Jenna