11 Replies Latest reply on Nov 13, 2012 1:22 PM by Mark Holtz

    multiplication of a month value with a month by category value

    Kerem Tomak


      I have a worksheet which has a calculated field with values by month.

      It looks like:

            Month | Multiplier.

      A second worksheet has:

            Month | Category | Field_1 | Field_2.

      I want a third worksheet which does this:

            Month | Category | Multiplier*Field_2 | Field_1.


      Multiplier *Field_2  currently gives me repeatedly the same number over all categories.

      Is this possible?