Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Year on Year Growth %

Help
2010-04-06
2013-04-29
  • Advait Pandit
    Advait Pandit
    2010-04-06

    Hi,

    I would like to create a schema where I have my Shops as Rows, and Gross Sales(Measure) and Time as my columns.

    How do I create a Schema which also has a calculated field that calculates the Sales Growth Performance % between this Period and the Previous Previous, and sorts the Shops by %  Growth?

    Something like this -

                                      2009                                       2010                       

                  Gross Sales   % Growth        Gross Sales      % Growth

    Store 3        10,000          -                            20,000          100

    Store 1        20,000          -                            20,000             0

    Store 2       100,000          -                            50,000          -50

    Thanks and regards,
    Advait

     
  • khandur
    khandur
    2010-04-06

    Hi!

    You need to create a calculated member, like this:

    with member . as '((., ..PrevMember) / (., ..CurrentMember))', FORMAT_STRING = "#,##0.00%"

    Hope this help.

     
  • Advait Pandit
    Advait Pandit
    2010-04-06

    Khandur,

    Thanks for your reply. How do I sort it now? The stores with the highest % needs to come first.