The problem I have here is with my calculation of Days in Period. The number of days in this period is 40, but because of the associative data model Steve smith only made sales on 34 of the 40 days so his days in period is only 34. I need the days in period column to be the same for each Sales Rep. (With the ability to make selections on dates which would change the number of days in period)
Sunny this is what I was looking for but to expand this problem a bit further. This pivot table is set up to let the user pick from a list of dimensions what id going to be displayed. When I change the dimensions to be
Sales Manager and MonthYear this logic does not work rather then days in timeframe being the the number of days in the month it shows number of days in entire year regardless of month.