none
Choosing a specific number of previous entries in a pivot table RRS feed

  • Question

  • 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.

    This link is exactly what I want. I really like the option to choose how many of the previous dates are seen.

    http://www.mediafire.com/view/9kr88r1f8pd7nnj/05_04_15c.xlsx

    • Edited by codys21 Friday, May 8, 2015 3:23 PM
    Friday, May 8, 2015 2:56 PM

All replies

  • Hi codys21,

    According to your description, I don’t understand clearly about your requirement, do you want to do excel automation from access?

    On the other hand, you could share the image files in the OneDrive.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, May 11, 2015 7:37 AM
    Moderator