Hello,
I want to project trending monthly sales using the MTD sales, divided by days worked, times working days. (MTD sales/days worked*working days). I have figure out the formulas using the pivot table cells but need to make it dynamic so the formula expands and contracts as the number of sales personal count changes.
Bookmarks