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
Hi all, I'm running a java web service based on JAX-WS the release included in java6, this application load the information from tables to data structures in memory such as hash map, and has it available for a client application that consume it. My p [More]
How do I get my Macbook Pro to fill in my name, address, city, state and zip automatically when I start to fill out and online form? It use to do it, all I did was put in the first few letters of my name and hit the tab button. Now it no longer does [More]
How many computers can be upgraded with one 1 purchase mountain lion?What if I have a Mac with a different apple ID. Can I sign out of that ID and sign in with my other ID and still download it with one purchase?Read other 4 answers [More]
Doesn't really have a question but rather a wish for Apple. I'm using my iPhone 4S for everything but find the calendar a but unsatisfying. Please give me the option to see the calendar on a weekly view and not only daily/monthly/list.Oh ****! Do I f [More]
Sr.No     Flt.NO     ORI- DES     Total Flts     TS OFF     FC     KC     TS Util      FC 1     IT101     BOM-BLR        20     2,680     400     2,280     2,165     230 2     IT103     BOM-BLR        20     3,216     480     2,736     2,322     245 [More]
Since I'm running Lion on one computer and can't upgrade, a view of the Appstore web pages by OS would be wonderful. Apple might even sell more Apps...Sorry but no.Read other 2 answers [More]
I swapped my iphone from apple store india and my imei of iphone changed and i have lost the box and bill of phone , how can i get my old imei number.Of course it changed. A phone's IMEI number is unique to each phone. The IMEI number for a phone doe [More]
I need the steps to upload from my email account an audiobook on to Itunes. any suggestions?If you mean that you are receiving an audiobook as an attachment to an email, then presuming that audiobook isn't copy-protected and locked to someone else's [More]
I only want to check in some metadata for search purpose. What should I do to allow ucm to do it without check in files? ThanksCheck out Kyle's blog post.Read other 4 answers [More]
Hello, I am doing something silly, and I can't figure it out. I want to use TreeSet with Objects, not strings, the code below throws a class cast exception: Exception in thread "main" java.lang.ClassCastException: com.generatescape.newtreemodel. [More]