Pivot table subtraction row
760572Dec 28 2011 — edited Apr 3 2012Hi 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