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:
Now in the query I have a selection variable for the date (on month = 03 in the example) and I need to show:
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