Ken, I tried your suggestion in my cross-tab. It's a lot simpler than what I came up with. I'm still fairly new to this, so I use the first thing I find that works. Now I know a better way. Thanks!
There are probably better solutions, but here is one I used for a similar problem:
1. Create a formula to return the first of the month for the date:
Formula = {File.DateField} - Weekday ({File.DateField}) + 1
2. Create a crosstab with the new formula as the column.
3. Modify the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.