Monday, September 15, 2008

Conditional formatting in pivot table:

I want to do conditional formatting on some columns
based on another column:

The requirement is, suppose a table having columns:

Country|Product|Amount
A Y 10k
B Z 30k
C X 20k
. . .
. . .

The rows should show in RGB color based on amount figure.
It is possible in table view to do conditional formatting
as
create another column apply the case
using max and min on amount then
three status we will get as 'max','min' and 'other'.Use this status
in other columns for conditional formating.

Hence we are able to do conditional formatting in this way in table view.
But the problem is if we take pivot table view of this, then we
r not able to get conditional formating in it.

Is their any way to achieve this in pivot table?

Thanx

Regards,
Vinay Porwal

1 comment:

sanmishra said...

I guess its possible in OBIEE and you are may be talking about an older version of siebel analytics.