I have two pivot tables, both tables have dates in one column and other column is the % difference from the top oldest date. I added a slicer to control both pivot table dates which works fine.
Say the slicer is currently on 1/1/2017 and the prices are show % difference from 1/1/2017, now when I bump the slicer by one date to say 1/2/2017 it makes 1/1/2017 hidden which is fine, but then the table fills with errors cause its still trying to show % difference from 1/1/2017 so I have to manually change it in each table, to pull from the new top oldest date.
Is there a way to automate this? Like I feel in the % difference from popup there should have more than just previous, next, or specific date, like there should be the top visible date. I tried recording a macro but it hardcoded the date that was selected so when the slicer changed and i ran the macro it threw up an error, surely im not the only one having probelms controlling two tables that has dates with a % difference. Cant seem to find a thread on it, any help is really appreciated.
Say the slicer is currently on 1/1/2017 and the prices are show % difference from 1/1/2017, now when I bump the slicer by one date to say 1/2/2017 it makes 1/1/2017 hidden which is fine, but then the table fills with errors cause its still trying to show % difference from 1/1/2017 so I have to manually change it in each table, to pull from the new top oldest date.
Is there a way to automate this? Like I feel in the % difference from popup there should have more than just previous, next, or specific date, like there should be the top visible date. I tried recording a macro but it hardcoded the date that was selected so when the slicer changed and i ran the macro it threw up an error, surely im not the only one having probelms controlling two tables that has dates with a % difference. Cant seem to find a thread on it, any help is really appreciated.
