1 Reply Latest reply: Dec 27, 2017 3:22 PM by William Fu RSS

    Above() & Before () for two dimensions on pivot table?

    William Fu

      Trying to create a measure that divides the current month value by the last month value.

      The catch is that I also want the last month value to be offset by one in the dimension I have for banding (Faixas de atraso).

      The desired result is a pivot table like below, where each cell is a division of itself by the number one band above and one month prior.

      In the highlighted cell, instead of 16, I want it to divide 16 by 36 (# from 2017-Nov's "1-30" band)

      I think I need a combination of Above() and/or Before(), but I'm not sure.

      pivott.PNG