Analytics Software

Dear all,

I would like to ask your help on how to calculate Month on Month growth rates [(last month - previous month)/previous month*100%] in an OBIEE query. This ratio should be always calculated for the last 2 available months.

I have the following query:
Month0 | Month1 | Month2
Product A 500 | 100 | 200
Product B 600 | 300 | 150

would like to add Month on Month column as following:
Month0 | Month1 | Month2 | Month on Month(%)
Product A 500 | 100 | 200 | +100.00%
Product B 600 | 300 | 150 | -50.00%

I tried to add a calculated item but it was not successful because I could not find out how to show only the calculated column as % with 2 decimals. Moreover, I would ideally prefer to have an automatic update but as far as I understood it can't be done in the calculated item automatically

I also tried to add a new column in the column area and to filter the results for the last month, then for the previous month and then based on it to calculate the needed ratio but unfortunately it also does not work out.

Thank you your hints in advance