Post reply

Sum 'LastPeriod' short version

  • April 8, 2013 at 8:26 pm

    #291928

    Maybe my last post was too long ...

    Does anyone know if the results of a 'LastPeriod' MDX query can be added together & if so, how?

    Thanks

  • April 8, 2013 at 11:41 pm

    #1604665

    Are you trying to produce a measure of adding 2 periods? eg. 11 + 12,

    or 201301+201302?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • April 9, 2013 at 1:35 am

    #1604701

    Hi Henrico,

    I want to add the Revenue for all the 3 months for a Quarter calculation & use this amount in a calculation.

    So I was thinking of using a function that will let me SUM the revenue for 3 month periods for example.

    Can I use LastPeriod for this?

    Hope this makes sense & thanks for replying

    Cheers

  • April 9, 2013 at 9:10 pm

    #1605082

    MORE INFO

    I have a Cube file with 24 months of data & one field has Revenue amounts.

    I want to nominate 3 consecutive months & add those months Revenue data together.

    Rather than use something like [Month].&[201206],[Revenue] + [Month].&[201207],[Revenue] + [Month].&[201208],[Revenue] is there a better way?

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply