Log In
Register
Home
May 10, 2022
Offline
Hello,
I need to produce the attached calendar view which places a X in the month the task would be delivered in. I would like to dynamically populate the calendar view based on filtered pivot table results. I thought of doing conditional formatting but having no luck with the formula. I also tried to maybe approach if from a chart perspective but no success there either.
Any help would be appreciated. The X values in the attached sheet are hard coded to show my intention.
See Answer
Trusted Members
Moderators
January 31, 2022
Offline
The calendar didn't come through. Please try again and don't forget to press the "Start upload" button before you submit your reply.
May 10, 2022
Offline
Sorry not sure what happened. Hopefully it attaches now.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
As you want it to be dynamic it is easiest to make the calendar in a pivot table, as shown in the attached copy.
If you want to have two separate tables, just make a copy of the existing pivot table and change the structure as needed. Instead of using filter, use slicers. With slicers you can connect two or more pivot tables that shares the same data cache, so when filtering all of the connected tables will be filtered.
Br,
Anders
Answers Post
1 Guest(s)
