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.
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 -
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,
You need to create a calculated member, like this:
with member . as '((., ..PrevMember) / (., ..CurrentMember))', FORMAT_STRING = "#,##0.00%"
Hope this help.
Thanks for your reply. How do I sort it now? The stores with the highest % needs to come first.