Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Conditional Formatting In Pivot Table
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.
Answers
-
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,
0 -
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.
0
