Home » Developer & Programmer » Reports & Discoverer » Complex situation (disc 10.1.2)
Complex situation [message #429955] Fri, 06 November 2009 08:30
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi,
In a report i have 2 fields and a page item, FY,AMOUNT,MONTH respectively. The AMOUNT is a calculated field (running total)-- for example when i select a"MAY" from the page item drop down the AMOUNT field gives the running total across the FY-2008,2009,2010 (CROSS TAB report). Now how do i get the percentage difference between the FY's 2008,2009,2010?
For example if i select the month July from the drop down list of the page item it must give me the "% difference" between 2008 and 2009,2009 and 2010?
Please any advice will be of great help, I used the LAG function but its not giving month wise its giving me for the whole year.

Thanks
Previous Topic: please need help with calculations
Next Topic: Group, Sort, Distinct????
Goto Forum:
  


Current Time: Wed Sep 28 12:34:20 CDT 2016

Total time taken to generate the page: 0.12414 seconds