cancel
Showing results for 
Search instead for 
Did you mean: 

To cummulate over 0calmonth range,

former_member713182
Participant
0 Kudos

Hi all:

How can I define a variable (or change in the KF) to have this:

The user will enter a range based on "month/year", and the report has to show the cummulated values of the keyfigure for this range, but as one value (not splitting month by month within the range).

Does anybody know how to do that?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Raj,

If i am not wrong then in your case user will enter Month range, for example 01.2008 to 10.2008

and then you want value of 01.2008 to 10.2008 in single column, M i right? If yes then don't go for drill down on Month you will get the single column.

correct me if i am wrong.

Answers (1)

Answers (1)

mansi_dandavate
Active Contributor
0 Kudos

Hi Raj,

You can keep calmonth in the free characteristics and create a variable on it.

So when the query is executed the key figures will show the cumulated value on all months range defined.

Regards,

Mansi