Currently I have one Key Figure, its settings are:
KF: GOD QTY
exception aggregation: LAST VALUE
aggregation ref char: 0CALDAY.
In the report we have 0CALMONTH in column, so we see last value of the month for the key figure (means whatever last day say 31.08.2009) and not the last value posted say 14.08.2009. In the report see value which is posted on 14.08. but using 0calmonth at report.
Can you tell me how do I change the above KF settings to get the last value posted for the KF? I still want to put 0CALMONTH at report level. What will be the changes at exception aggregation and aggregation ref char?
Thanks in advance,