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!