JustJoker Posted January 31, 2011 Share Posted January 31, 2011 Hello! I'm trying to figure out how to make a report with option to group data and totals by months and quarters of a year. Knowing how to find a range of dates with globals, I just don't understand how to find several ranges and group data in a readable report. Does somebody have any clues? Sorry for this may be silly question. Thank you in advance, Serge Link to comment Share on other sites More sharing options...
comment Posted January 31, 2011 Share Posted January 31, 2011 Records are grouped by a common value in the breakfield. To group by month, you need a calculation field that will return the same value for all records in the same month, e.g. = TransactionDate - Day ( TransactionDate ) + 1 Use this field for sorting and for the sub-summary part. Not sure what you mean by "find several ranges". Link to comment Share on other sites More sharing options...
JustJoker Posted January 31, 2011 Author Share Posted January 31, 2011 Thank you, will try Will it be possible to add quarters and years as sub-summary that way to make it look like: month1 month2 month3 ------- Q1 ------- month4 . . Q4 --------- Year ? Link to comment Share on other sites More sharing options...
comment Posted January 31, 2011 Share Posted January 31, 2011 Yes - provided you have a breakfield and a sub-summary part for each group (month, quarter, year). Link to comment Share on other sites More sharing options...
JustJoker Posted January 31, 2011 Author Share Posted January 31, 2011 Thank you very much Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4388 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now