Hello all,
I have an issue with a pivot table.
So I am pulling the data from a system which updates every morning and has new counterparties added to it. However, there are certain counterparties on this list which I need to remove. However, if i un-filter them when I update the pivot in the morning, any new counterparties added to the system overnight do not appear and I need them to appear.
Any ideas how to bypass this?
Thank you,
Chris
Do you click on "Refresh" (right click on the pivot table and then choose "Refresh" from the menu)?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
hi ChemistB,
yes thats how the new counterparties pull through, but they are not selected on the dropdown.
Hi,
Right click the field you are filtering and select Field Settings, then check the 'Include new items in manual filter' option.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks