I have an Excel 2010 workbook that includes the detail for a portion of the population of data. The portion was selected based on certain criteria. Research was completed to test compliance. The results are displayed in a pivot table.
I need to calculate error rate based on a second report that contains population count at the company, district, and location level.
I've tried adding the population to a new column in the detail as a lookup then adding this column to the pivot table with a Max value which may work for one monthly period but will not work for future monthlt/Qtrly/YTD purposes. advice/suggestion is welcome!
I need to calculate error rate based on a second report that contains population count at the company, district, and location level.
I've tried adding the population to a new column in the detail as a lookup then adding this column to the pivot table with a Max value which may work for one monthly period but will not work for future monthlt/Qtrly/YTD purposes. advice/suggestion is welcome!