Home > Default > Conditional formatting with another column in pivot table

Conditional formatting with another column in pivot table

November 30Hits:0
Advertisement
Hi everbody please help me!
My question is simple.
On my example I have
--------------------year1------year2----dif(my calculated item)
measure1-------100-------50---------50
measure2-------75-------100---------(-25)
For measure1;
I want to make "dif" green if year1 is < 100 and want to make "dif" red if year2 = 100 and etc...
Is it possible, I tried but could not achive conditional formatting when I use different column then dif...
Thank you for your help
Regards,
Can
Edited by: canmurt on Dec 27, 2009 9:44 AM

Answers

Thank you for quick answer, but there is no "Admin General privileges" :(
Do u know anything about first question
Access to Dashboards
Access to Answers
Access to Delivers
Access to Briefing Books
Access to Disconnected Analytics
Access to Administration
Access to Segments
Access to Segment
Access to List Formats
Access to Metadata Dictionary
Access to Oracle BI Publisher Enterprise
Access to Oracle BI for Microsoft Office
Regards;

Read other 7 answers

Tags:

Related Articles

  • Conditional formatting with another column in pivot tableNovember 30

    Hi everbody please help me! My question is simple. On my example I have --------------------year1------year2----dif(my calculated item) measure1-------100-------50---------50 measure2-------75-------100---------(-25) For measure1; I want to make "dif

  • Conditional formatting on total cells in pivot tableNovember 30

    Hi, i have a pivot table with some values and percentages. The percentages are in red if less then 0. I have 1 row and 1 column of total values, but this cell aren't red if percentage is less then 0. Does anybody know a solution for my problem? Thank

  • Calculated Percentage Columns in Pivot Table loose formating in ExcelNovember 30

    I have a simple report built using pivot table ( OBIEE 11.1.1.5.0) 1 Metric and 1 dimension using pivot table. and I duplicated the metric column and change it to % column.(Show data as % of column). SO far so good. Below is the snapshot http://tinyp

  • How to extend No. of columns for PIVOT table in BI Publisher DesktopOctober 11

    Hello Everyone,   I am using the Oracle BI Publisher Desktop to design the TEMPLATE for Oracle Reports. I need to create the PIVOT table .In my PIVOT table I need to display 9 columns but when I tried to create PIVOT table by dragging 9 columns only

  • How can we modify the maximum no. of columns in pivot table ?October 11

    hi all, How can we modify the maximum no. of columns in pivot table ? do i need to change the nqconfig.ini or instanceconfig file or else? thnx..A little search on the forum : In the instanceconfig.xml add a <PivotView> element under <ServerInsta

  • Calculation on two columns in pivot tableNovember 30

    Hello all, I have a view: Dept Year Amount Accounting $500 2010 Accounting $700 2011 Engineering $100 2010 Engineering $600 2011 and etc pivot table:(data displayed side by side) Dept: 2010 2011 Accounting $500 $700 Engineering $100 $600 Is there a w

  • Formating column in Pivot Table (Hyperion Interactive Reporting 9.3.1)November 30

    I have a simple pivot table with multiple columns (8) and I have 6 different pivots. I drag the pivots into the report section, but none of the column widths or row heights align properly. How do you size the column widths in each pivot and I'm tryin

  • How to hide/suppress empty columns in pivot tablesNovember 30

    In a pivot table, is there any way to do something like "suppress missing data" to make an entire column hidden only if it is empty? I have a situation where I can't hide an entire measure because the measure has values for another dimension, bu

  • Suppressing Columns in Pivot table when adding subtotalOctober 11

    Hi, We have a dimension hierarchy like this: Level 1 ---> Level 2 ---> Level 3 T ---> A ----> B1 T ---> A ----> B2 T ---> C ----> D T ---> E ----> E The report we are trying to build is of this format: Row_Num --> Dimensio

  • Using conditional formating on member columns in essbase hirarchy in obieeNovember 30

    Hi All, I ws analysing an existing sample PnL report in obiee 11g. Wht I found that there is conditional formating used on 'Balance' member column based on one of the member column (net income) from 'income statement' hirarchy of essbase cube. I trie

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.482 s.