Ross Turner
asked on
SRSS: Current / Last Fiscal Year Sum Calculation?
Hi EE,
I’m new to SQL Server Reporting Services but what I’m trying to achieve is creating a field on the report that looks at a total sum of product sold in the Current Fiscal Year (Starting 01-05-2011 to 30/11/2011) and then also have second field which looks at the a total sum of product sold for Last Fiscal Year (Starting 01-05-2010 to 30/11/2010) the end dates for both would then change to last day of Current December \ Last December when we get into January and so on.
Has anyone done anything like this before in SRSS
Thank you for all you Help in Advance :)
Ross
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.