Forum Discussion
rosscortb
Post Patron
Post PatronHelp with Annual Leave Matrix excluding weekends
Hello I have managed to adapt the idea posted here - Project Timeline to create a annual leave Matrix which shows employees Approved and Submitted Leave. Thought I had it cracked it but real...
So you want to filter out the columns with the weekends?
If you have a date dimension connected to those days, mark weekday/weekends in the table then use that value to filter out columns in the matrix.
? I don't see A on Sat/Sun...
rosscortbPost Patron
Post PatronHello Anonymous
The 1/2/8/9/15/16/22/23/29/1/ of Feb are weekends so annual leave should not show.
Cheers
Ross
So you want to filter out the columns with the weekends?
If you have a date dimension connected to those days, mark weekday/weekends in the table then use that value to filter out columns in the matrix.