

Creator II
2017-12-27
03:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Above() & Before () for two dimensions on pivot table?
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.
1,463 Views
1 Reply


Creator II
2017-12-27
03:22 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nevermind, it works with Above(Before(*measure here*)) in the pivot table..
1,252 Views
