| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
