Multiple Date Range in One Report

[cguyreports]

I am using xi and have a report that requires to columns of data first column they want to see a count by the last week so I am using the lastfullweek function. next they want to see a count of everything from the first day of the month to the last day of the lastfullweek. Any suggestions on how to get this to work would be very appreicated!

 

[lbass]

Try:

if {table.date} in maximum(lastfullweek)-day(maximum(lastfullweek))+1 to maximum(lastfullweek) then 1

Right click on this formula in the detail section and insert a summary(SUM, not count).

-LB

 

[cguyreports]

awesome! thank you very much.