4 Replies Latest reply on Nov 8, 2016 4:05 PM by Tracey Dong

    How to calculate # of holidays at higher level

    Tracey Dong

      Hi all,

       

      I am stuck today. In the data source, I have holidays against each week(WeekStart). But WeekStart is associated with AssignmentID. How do I get the # of Holidays at a higher level, not on AssignmentID level? meaning I want # of Holidays in the below table all shows 2.

       

       

       

      Workbook is attached.

       

      I need help!

       

      Thank you!