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
Hello All, One of customer background job running for long time more than 11 hours, but usually this jobs get completed within 4 hrs. I have checked in WP trace file, it shows "WP has reached abap/heaplimit=40000000". This is the Value I can see [More]
i cant invite my game center friend for multiplay games suddenly. my wife and i usually play some multiplay games ( like gun bros, finger soccer...) by inviting each other throught game center. it went well until this Tuesday, we suddenly cant invite [More]
I set up my new phone and all went well, or so I thought, but not all my photos transferred.  What apparently happened is my phone stopped backing up in the iCloud awhile ago due to being over the limit.  It is the photos from that point forward that [More]
I'm trying to get my Brother MFC-7360N usb printer to work but so far all I can make it do is feed some paper. I'm using cups-usblp since I couldn't even get paper to feed with regular cups. There is a PPD for the printer but it doesn't respond at al [More]
Has anyone get this built_in working correctly: set_item_instance_property('blk1.item1',i,BORDER_BEVEL,LOWERED); I also tried set_item_instance_property('blk1.item1',i,BORDER_BEVEL,'LOWERED'); I got this error for both: FRM-41384: Invalid parameter u [More]
I installed the new version of itunes on my computer. I do not like it i want to go back to the version before. If i uninstall my program will i loose all of my music that i have in my itunes. Or will it auto matically put it back in it??well there i [More]
Yes, I know all about the "Do Not Call" list, and the laws, blah, blah, blah.... these annoying calls from 800, 866, "Unlisted", "Anonymous" and "Toll Free" still happen.  And, there is no point in trying to save on [More]
HI Friends, I need your guidance to find out the Outstanding loan balance amount of an employee (str: Q0045-OPELO as in PA30). I tried with FM : PYXX_READ_PAYROLL_RESULT. But the wage type of /LLB or /LFP or /LTE are not available in my RT or any oth [More]
Anyone else having this problem? I've tried restarting my phone but it didn't resolve the issue.Thanks, but this did not work either. The problem seems to have resolved itself overnight though..Read other 3 answers [More]
Using SQL Developer on a local database is just as quick as TOAD but when I connect to a remote database the tool becomes unusable even though we have a super fast pipe to the remote location. TOAD is also affected by the remote connection but I woul [More]