Hi all,

I have a pivot table that I am using to create a dashboard using Slicers.

I want to have a section of the dashboard that displays average sales for the customer depending upon the number of months selected. For example, if the Slicers are set to 2013 and January, then I want the total sales for a customer to appear in one section of the dashboard, and then the average based upon 31 days to appear in another.

This is where it now gets tricky. If I select multiple months I want the data to show the total sales for those multiple months (Thats the simple part) but then the average based upon the number of days within those calendar months.

Is this possible? either using the pivot filters within a formula or using the slicers?

Chris