Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between columns

767676Apr 19 2010 — edited May 13 2010

Hi all,

I have a situation like the one pointed out in the picture here: http://i40.tinypic.com/dlq5tz.jpg

This is a pivot table, and it extracts the Products and their average on the shelf on the last month and the same period one year ago.

I would like to have a column that gives me an indicator (could be a sum or difference) in order to understand if the current month value is greater than the previous one; in this way, I could set a conditional formatting rule that displays an "up arrow" or "down arrow" depending of the trend.

Thanks for the help!

Best regards,
Alberto

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2010

Added on Apr 19 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

8 comments

1,242 views