1 Reply Latest reply: Jul 17, 2017 10:27 AM by Stefan Wühl RSS

    Set analysis: use value of other dimension

    Wim Rijken

      I have a very simple data model:

       

      Product

      Posting Date

      Posting Month (derived from Posting Date)

      Posting Year (derived from Posting Date)

      Document Date

      Document Month (derived from Document Date)

      Document Year (derived from Document Date)

      Amount

       

      I would like to create a Pivot table:

      • rows: product
      • columns: Posting Year and Posting Month
      • expressions:
        • Amount based on Posting Year/Month > this is simple, just add the expression: sum(Amount)
        • Amount based on Document Month > what is the formula for this?

      So something like: Sum({$<Posting Year=,Document Year={Posting Year}>} _Amount)

       

      Do I need set analysis for this, or can I achieve this in another way?