Conditional Formatting In Pivot Table

Question

I have 3 columns in my Pivot Table.

Status

Month (Filtered for January and February)

Revenue

The "Status" column will contain a conditional format as follows:

If Revenue for February is greater than Revenue for January then "Good" else "Bad".

Not sure how to pull this off. Can I use a FILTER statement or is it better to use a CASE statement here or is it possible to use both: I have tried below but it did not work.

CASE WHEN

FILTER(Revenue USING (Month = 'February')) > FILTER(Revenue USING (Month = 'January')) THEN 'Good'

ELSE 'Bad'

END

Any ideas are welcome.

Joel Acha · Answer

+1 @cesar.advincula.o

You'll need to use the AGO function to retrieve the measure value for the previous period in order to compare current value with previous value for each row.

cesar.advincula.o · Answer

Hello,

The question is:

" Why we are using FILTER to compare for these two months ( "February and January"), it is not real dynamic? "

I propouse to use AGO function, to get the dynamic status.

Note:

AGO Function could implement by Oracle BI Presentation Services or Oracle BI Administration Tool.

- Oracle BI Administration Tool:  check http://gerardnico.com/wiki/dat/obiee/ago

- Oracle BI Presentation Services - Oracle BI Answers:

Check this steps.

Criteria

Edit Formula by Column:

Results:

Kind Regards,