3 Replies Latest reply: Feb 27, 2014 6:26 AM by Friedrich Hofmann RSS

    Sum above values only when a dimension value is equal to the current one

    Martino Vedana

      Hi guys, I can't figure out how to sum above rows only when the rows have a field value equal to the current one.

      Two dimensions: CAR and COLOR

      Value QUANTITY

       

      Let's see the source table:

      source.png

       

      I'd like sum for eache row above quantity + current quantity only when color equals to the current one.is what I expect to obtain.

      2014-02-27-1141 -001.png

       

      How can I obtain it with formulas ?

       

      thank you