special Keyfigure calculation in BW query designer

[oliver_raths]

When calculating a key figure (Net value YTM), the sales of all months up to the month that is currently displayed in the outline should be summed up.

How would such a key figure calculation have to be defined in the query designer ?

see attachment

thx, br oliver

[csplkr]

Hello,

there are multiple possible ways to do this. For a simple use case, you could duplicate the keyfigure selection and have it be cumulated in the selection properties. 

Another option would be to use a CURRENT MEMBER Variable for your time dimension and restrict your  keyfigure on an interval from the first month of the year to the current one for each row using said variable. Check out a more detailed description to solve your problem with CURRENT MEMBER here and here(YTD analysis).

Best Regards