Forum Discussion

rosscortb's avatar
rosscortb
Icon for Post Patron rankPost Patron
6 years ago
Solved

Help 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 realised it shows A on Saturday/Sunday.

 

Any ideas what I need to do to prevent that? thanks Ross

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    ? I don't see A on Sat/Sun...

    • rosscortb's avatar
      rosscortb
      Icon for Post Patron rankPost Patron
      6 years ago

      Hello Anonymous 

       

      The 1/2/8/9/15/16/22/23/29/1/ of Feb are weekends so annual leave should not show.

       

      Cheers


      Ross

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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.