I created a slicer for a pivot table with the option to change the timeframe from last 52 weeks to last 12 weeks. My problem is when you don't choose one or the other the pivot table adds both timeframes together and obviously that is not giving an accurate description of the data. Any suggestions?