Skip to Content
avatar image
Former Member

Cumulative per year

Hello all,

How can I ensure that my key figure is cumulated only per fiscal year?

Thus, now I have:

January 2006 - 8.850.678

February 2006 - 17.449.955

March 2006 - 25.914.014

April 2006 - 32.849.374

May 2006 - 39.631.877

June 2006 - 46.682.151

July 2006 - 55.484.241

August 2006 - 64.676.416

September 2006 - 72.477.761

October 2006 - 80.969.174

November 2006 - 90.091.606

December 2006 - 98.864.938

<i><b>January 2007 - 107.441.106

February 2007 - 115.239.376</b></i>

And I would like to have:

January 2006 - 8.850.678

February 2006 - 17.449.955

March 2006 - 25.914.014

April 2006 - 32.849.374

May 2006 - 39.631.877

June 2006 - 46.682.151

July 2006 - 55.484.241

August 2006 - 64.676.416

September 2006 - 72.477.761

October 2006 - 80.969.174

November 2006 - 90.091.606

December 2006 - 98.864.938

<i><b>January 2007 - 8.576.168

February 2007 - 16.365.438</b></i>

Thanks in advance,

Ralph

  • points will be awarded

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 11:25 AM

    Hi,

    drilldown both Fiscal Year (0FISCYEAR) and posting period (0FISCPER3) instead of the combination fiscal year/period (0FISCPER).

    hope this helps...

    Olivier.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Olivier,

      thanks for your respons !!!

      I think we then have to solve this in the back end and add a YTD version of the key figure in our cube.

      Best regards,

      Ralph