Skip to Content
0
Former Member
Aug 26, 2009 at 10:37 AM

Key Figure aggregation settings

16 Views

Hi Guys,

Currently I have one Key Figure, its settings are:

KF: GOD QTY

aggregation: SUM

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,

BMW Z4.