Hi, gurus,
I'm coding to manipulate power pivottable but ran into a problem.
The issue is how to assign the latest date in table "Dates" to the page filter "Date" of ppvt, ie "2020/3/23" to Sheet2!C2.
It seems many attributes or references of ppvt is waaaaaaay different from normal pvt
Pls see attached file with mock-up data.
Thank you for your help and take care, stay safe!
How about this: add an extra table with only the last date, to be made like this:
and then link this to your pivot
Please Login or Register to view this content.
Cheers
Erwin
I started learning VBA because I was lazy...
Still developing.... being more lazy...
Beste Eastw00d, bedankt voor je hulp!Originally Posted by Eastw00d
How about this: add an extra table with only the last date, to be made like this:
and then link this to your pivotPlease Login or Register to view this content.
Cheers
Erwin
As I'd use other date options in the page filter for some other functionalities, I'm afraid your suggestion doesn't fit in the case.
In fact, what I want is to automate with VBA the page filter to choose the latest date in the Dates table after each update.
Take care and stay safe!
under construction....
Last edited by Eastw00d; 04-04-2020 at 02:53 AM.
Administrative Note:
Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks
Het is gelukt!
You still need the offset formula, or you have to set the date otherwise. I put this in "H1".
This procedure passes the value of the cell in the worksheet "DS" on to your pivot filter:
CheersPlease Login or Register to view this content.
Erwin
Fatastishch! Hartelijk bedankt, Eastw00d! Mijn ontwinkkeling verbetert nu dankzij dit hulp.
Fijn weekend!
Please stick to English unless posting in the Non-English Excel section. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks