Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table that has 2 dimensions - product description and month number (MONTH_NUM).
In the expressions, I have 3 expressions for calculation:
1. Sum({<YEAR_TRN_DATE={'$(vGBL_PreviousYear)'}, MONTH_NUM={'<=$(vGBL_MaxMonth_Num)'}>} TRN_DET_STD_NTO)
2. Sum({<YEAR_TRN_DATE={'$(vGBL_MaxYear)'}, MONTH_NUM={'<=$(vGBL_MaxMonth_Num)'}>} TRN_DET_STD_NTO)
3. Column (2) - Column (1) = Difference
MONTH_NUM has 12 values from 1 - 12.
vGBL_PreviousYear point to previous year, vGBL_MaxYear is the current year, vGBL_MaxMonth_Num is the current month number
I'd like to make a pivot table that shows all calendar months as columns, and calculates the values in the columns by their respective months. Currently the pivot table shows only 2 months (Jan-Feb)
Does anyone have an example on how to do that?
The reason should be MONTH_NUM={'<=$(vGBL_MaxMonth_Num)'} and I think you didn't need it.
- Marcus