I have a question - i have a request from management to do a average by month for a running total of sale Deals.
In the view, we had rounded each rep to deal total by month, so the month always returns the first of the month so we can run totals by month.
So for example the table looks like this:
Sales Rep
TotalDeals
Month
John Doe
14
09/1/2017
Steve Joe
10
09/1/2017
John Doe
5
08/01/2017
Steve Joe
8
08/01/2017
I have sale deals coming in as a sum in a pivot as measures, the exec wants a running average... so if he chooses 5 months, he wants it to do an average by 5 months...
Sum(TotalDeals)/MONTHS CHOSEN
How would i return the selected months he is using, the date is a column and the measures are above.
