Hi there,
I have various big pivot tables in which new data is added each day. I have a method to extract data from a sample of the last 28 days for example. However, the fields provide data at varying frequencies, so for one field I may have 100 entries and another only 5 in those 28 days. What I would ideally love to be able to do is only sample the latest 20 from each field, instead of the parameter of 28 days. Can anyone help?
MANY THANKS!
Gav
show an excel file, without confidentional infomation.
please also add the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
created a sample to post but file is far too large. Can email privately?
The desired result is:
The Pivot Table only displays data from latest 20 entries per column field. I guess the answer might be to create a new data set from the original by finding the last 20 entries with COUNTIFS?
why not just post a small excel (a part of your file) example.
PIVOT HELP.xlsb
Here you go, I have sampled it even further. A good example of what I want to achieve is on Sheet2 Columns Q to S - the field "Alan McCabe". "Sum of Race" is the total amount of entries (15). This is spread over the 9 day period I have sampled. However (for the sake of this example), instead of sampling all 15 entries in this period, is there a way of sampling or extracting the data for just the latest 5 entries for this field?
Always the last 5 entries?
or
The last 5 entries per day?
In both cases (I think) you don't get results (values) which you can compare sencefull to other names.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks