Sitemap

Amicuk Programming Answers

Pivot table subtraction row

-0001-11-30   Views:1

Advertisement

Hi there, Is it possible to subtract the values of two rows in a pivot table and show as the third row if we can assure that there will always be only two rows in the pivot table? Pivot table view: h2. Year  M01   M02   M03    Q01 Total_ *2009*    49

Hi there,
Is it possible to subtract the values of two rows in a pivot table and show as the third row if we can assure that there will always be only two rows in the pivot table?
Pivot table view:
h2. Year  M01   M02   M03    Q01 Total_
*2009*    493    437    529    *1459*
*2010*    599    579    643    *1,821*
Problem: I am trying to generate another row in the bottom (In the place of Grand Total) and show the result of M01-M02.
Underlying data columns:
Year, Month, Quarter, #Orders
Underlying Filter: (this assures 2 years)
Year IN "Previous Year", "Current Year"
Version: OBIEE 10
thanks!
Edited by: obitime on Dec 28, 2011 9:45 PM

The replay answer
Advertisement
Instead of using a pivot table that way, create seperate measures using the filter function:
current year amt = filter(measure using year=[current year])
previous year amt = filter(measure using year=[current year] - 1)
change amt = filter(measure using year=[current year]) - filter(measure using year=[current year] - 1)
You may want to define [current year] using a prompt which sets a variable.
A second option is to write a formula like case when year = [current year] then 'Current Year' else 'Previous Year' end, and use that in your pivot table in place of Year. That way you can create your calculated item formula on something more dynamic.
Regards,
Robert

Go to See the other 7 answers

Pivot table subtraction row

Category:DefaultRelease time:-0001-11-30Views:130

Hi there, Is it possible to subtract the values of two rows in a pivot table and show as the third row if we can assure that there will always be only two rows in the pivot table? Pivot table view: h2. Year  M01   M02   M03    Q01 Total_ *2009*    49[More]

Pivot table alternating row colors

Category:DefaultRelease time:-0001-11-30Views:130

Hello, In ADF 11g, is it possible to format a pivot table so row colors will alternate? 1st row gray, second row white, 3rd row gray and so on.. Can i determine which row is a DataCellContext object in ? Thanks.Any ideas ? I still could not find a wa[More]

Percentage calculation in pivot table per row

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I do calculate two fields in a pivot table. First calculated field is the # of activities per user (standard SoD reporting field). Second calculated field is the # of activities per user with a certain classification (customized pick list[More]

Above Average Conditional Formatting in Pivot Table off Row Total

Category:DefaultRelease time:-0001-11-30Views:130

I have a pivot table where the months are column labels and the actual issues are Row labels. This is inverted from a normal pivot table where the months are usually the row labels. Basically I want the table to look at the value in the Values cells[More]

Pivot Table - adding row header detail

Category:DefaultRelease time:-0001-11-30Views:130

I've created a pivot table output using template builder for word plugin (10.1.3.4.2) xml <XXNCC_APEDI_3PINT> <P_FROM_DATE>2012-01-03T00:00:00.000+00:00</P_FROM_DATE><P_TO_DATE>2012-03-31T00:00:00.000+01:00</P_TO_DATE> <LI[More]

How to move excluded items into Measures in OBIEE 11g Pivot Table

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, Need your help. Previously I have about 25 facts in my pivot table as rows. Now I need to add about 10 more. Adding new criteria only put the items into Excluded section. How can I move all these new items at once to the end of the existing f[More]

Request in Pivot Table - HELP

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have created a request in Pivot Table. Rows section Include Product Domain column and Columns Section Includes Month ; measures section contains columns gross, profit, loss and YTD %. I want YTD% column to appear after Dec month and it is shoul[More]

Error in displaying pivot table

Category:DefaultRelease time:-0001-11-30Views:130

Hi everyone, I have't seen any thread that gives me an answer to my problem. I have OBI SE 10.1.3.4 on Windows Server 2003. In physical layer i've table REQUEST: Pack varchar, Seg varchar, State varchar, SUM_ACT double, SUM_PRE double. I mapped REQUE[More]

OBIEE: Pivot table chart is not proper when GOURL is on Measure Column

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I a facing an issue with Pivot table chart drill. Pivot Table columns: Row description column in row section. Column description (Periods) in column section and A Number format amount column in Measure Section (In BMM it is not defined as a m[More]

How to make a layer from the ADF pivot table invisible , show-hide column-row-data

Category:DefaultRelease time:2015-10-11Views:130

Hello all , I need to create a pivottable with ADF 12c for reporting purposes. I have a table or view with 10 items of type VARCHAR2 , C1,C2,C3,C4,C5,C6,C7,C8,C9,C10  and   10 items of type NUMBER N1,N2,N3,N4,N5,N6,N7,N8,N9,N10 The items of type VARC[More]

Measures as Rows in Pivot Table? OBIEE 11g

Category:DefaultRelease time:2015-10-11Views:130

Hi, Is it possible to show measures as rows and attributes as columns? I have only one value in my attribute columns. example: --------Company(Oracle)-----Country(India) Sales        100                  20000 Units         50                  40000T[More]

Hot
Is there a way to copy non-contiguous words from a PDF?  Is there a way to use a template or mask that will isolate certian areas to be copied with spaces in between the words so that when you go to paste the contents into multiiple fileds, the separ [More]
Hello all, I have seen others with a similar problem to mine. I live in a 2007 developed block of flats in Cheltenham.  My Neighbour who is 50 yards away can get the BT Faster Total Broadband at 9-15MBs and yet I cannot.  We are both linked to the sa [More]
Hello, my name is Chris. I am just learning to use LabView. Everything I have learned so far is through these boards. Which is a valuable tool for someone learning. The VI I am working on is to monitor current from a unit we are testing. I am able to [More]
We were able to install and configure Workspace/Shared Services, Essbase, Planning, Financial Reporting, and OHS in our new 11.1.2.5 environment, all running on Red Hat Linux 5.8.  However, when we try to start the planning service, it gets stuck in [More]
Hello SAP guru's, I would like to know the functionality of transaction code 1KEH in EC-PCA module. how does it works, when you run as part of month end activities is there any financial accounting impact? kindly let me know step by step process of t [More]
When i try to resend an iMessage the IOS 6 send a normal message SMS in the setting in message i have set no for send SMS when IMessage is not avaiable. ITALIANO: Quando il telefono con IOS 6.1.2 non riesce ad inviare un iMessage e provo a reinviarlo [More]
Hi, I'm using Discoverer 4i Viewer with E_Business and I create a new EUL. How can I switch from the old EUL to the new one in order to see my reports ? I found this note on the Discoverer Forum: "Looks like you are using Oracle E-Business. If you la [More]
Hello. I've set up kerbros auth in test oracle 10g r2 database on 64-bit linux according to Oracle® Database Advanced Security Administrator's Guide. I have the following issue: kerberos user can login to the test server (from this server) and normal [More]
OK, long story, but stay with me.... could be an interesting one here. So I move to a SSD hard drive in my 24" iMac. New Intel SSD drive is only 160GB, so I'm only using it for the OS, Applications, etc... all of my data is on an external FW800 disk [More]
When I start Firefox. I get a message that it can't run an update because another version is running. blah blah ... I have verified that there is not another version of Firefox running and the processes don't show anything either. What is wrong? Anot [More]