Hello,
I was directed here from the MS technet forum for an answer to my question.
What I have is an Access form that links to an Excel document where I analyze the data, make it look nice, etc.
I am doing this on a work computer that has Office 2013 (which I won't have access too until tomorrow morning.)
I am not sure if it is the Pro Plus version. I have attached a part of my spreadsheet, edited for privacy. The three most important slicers are Site, Supervisor, and Employee. Auditor, date, and two of the criteria also have slicers. Each column has 13 criteria
(5 shown in example). I have another sheet with 13 pie charts with connected slicers that show the percentage of true vs false for each of the 13 criteria. Typically what is going to happen is a supervisor will filter by employee so that they are only looking
at one employees statistics at a time. So what I want is to be able to use those pie charts, but only to have the last five entries (or a specific number chosen like in your example) from each person to be shown in the charts.
Apparently I cannot submit a picture until my account is verified. How do I verify my account?
Until then, the column headers in my spreadsheet are ID (from Access), Site (1 of 2 locations), Program, Employee, Auditor, Supervisor, Call Date, Score, Under 30 days (True/False), 13 criteria (all True/False), and a few other sections from the Access form which will not appear in any pivottables/pivotcharts.
Other recent topics
