I have sales data for Clients that has the client name month and year(combined for date) and revenue for each month. I would like to take all clients in a given month and see the average revenue per client and then be able to display that in a bar chart by month. Does anyone know an easy way to do this? I also have the data loaded into a PowerPivot Data Model.
Bookmarks