Characteristic restriction with another characteristic
Hello and good day to you guys, I have a quite uneasy problem and need your wise help on this.
I need to restrict a characteristic with a date so I can get to display the last value of that characteristic only even when the original selection involves several dates
Here are my facts:
I'm reporting on an ODS level and in the ODS I have:
Project__Month__Amount__Status
PR1______01_____100_____A
PR1______02_____150_____B
PR1______03_____600_____C
Now in the query I have a selection variable for the date (on month = 03 in the example) and I need to show:
Proyect__month__Amt.__Amt.previous month__Status
PR1_____03_____600___150_________________C
As you see I am displaying the amount for the selected month, the amount for the previous month and the status of the selected month as well.
I have a variable for selecting the wanted month and then via an offset I actually do the select on the selected month + the previous month-1, so then by restricting the KF amount I get the current and the previous amount but I'm not able (because of the initial selection of the 2 months) to display the last status ( as I canot restrict the characteristic by another (month) characteristic so I end up getting 2 lines displayed with the diferent status B and C and I need just C.
Any ideas on how to achieve that ?
Thank you very much
Herny