1 Reply Latest reply on May 25, 2016 9:47 PM by Bill Lyons

    Combining two worksheets

    Ashley Cloutier

      Is there a way to combine tables or calculations from two separate worksheets. If you look at my attached workbook, you will see I have a worksheet with average headcounts and then I also have worksheets with voluntary and involuntary terminations. I need to take the number of terminations and divide them by my average headcount to calculate our turnover. How can I go about doing this?

        • 1. Re: Combining two worksheets
          Bill Lyons

          Thank you for including a packaged workbook!

           

          Are you wanting something like the sheet "Turnover Calc" in the attached? The keys here are to use Level of Detail (LoD) calculations for [Average Headcount] and [Terminations]. In [Terminations], there is the addition of the condition that counts only if [Total Terms] = 'Termed'. Then, the [Turnover] is simple division. I used INCLUDE type LoDs so it adds to the existing Days and Region filters. The alternative would be to use FIXED LoDs and add those filters to the Context.

           

          It should be noted that the total terminations (695) is more than the sum of involuntary (393) and voluntary (301) because there is one record where the term type is null.

           

          I hope that helps. Questions?