2 Replies Latest reply on Mar 16, 2017 11:01 AM by dipti.patel.2

    Cumulative SUM across Months

    dipti.patel.2

      For the below table I want to count the quantity to be cumulative across Months starting Jan

       

      So for Furniture > Bookcases > January > Quantity is 14

      And for Furniture > Bookcases > February > Quantity is 2

       

      So when a user select Jan since its the first month the actual quantity values are shown.

      But when a user selects Feb then I want the quantity to be 14 + 2 = 16

      So on then as user selects other months going forward for that year.

      How do I achieve this?

       

      Jan -

       

      Feb -