Oracle Communities

Oracle Analytics and AI

Child Item

Conditional Formatting on Grand Totals

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Oracle

Description (Required):

Currently (OAC version 6.3), Conditional Formatting cannot be applied on Grand Total numbers (example in printscreen attached > Grand Total columns, right hand side), which defaults to gray, regardless of the conditional formatting applied on that column.

Use Case and Business Need (Required):

Business needs to be able to easily see which information they need to check first (i.e. Red/Green numbers). Using the conditional formatting will help them identify KPIs that are meet or missed and extending Conditional Formatting to apply on Grand Total generated columns will help them even more.

image.png

Enhancement Request / Service Request:

Find more posts tagged with

Delivered

Reporting

Analysis and Data Visualization

Status: Delivered

Comments

pungaret-Oracle

That would be great

User_611V0

This is a critical feature for any report with conditional formatting

User_YB2AF

This would be a very helpful addition

User737781-Oracle

This is a top request from the SVP/GVPs of the business.

User_E35E6

This is a much needed feature for KPI reporting

Laura Flores-68492

This will be a critical feature as sales leaders are having trouble finding grand totals easily

Jacques V.-Oracle

Hello,

This is more difficult to support than you would imagine. the totals are calculated on the table after the data is retrieved. Also the totals are not necessarily simple sums on the viz which adds extra complexity.

Having said that we are looking at this for a future release but no timeline has been set yet.

In the meantime, if you create a Calculation and use that on your table then you could create a CF rule on the Total calc.

Have you tried that ?

User_OS4PZ

Please include Conditional formatting to Grand total in DV as individual Vs. Grand total Significant changes currently we are not able to highlight it.

pungaret-Oracle

J-

here is an example:

we'd like to see the grand total and quarterly totals CFed

Angel Shipp

A much needed enhancement for our user groups as well.