Hi All

I have a question and am not sure if it is possible to do and if so how to do it.

I have a PowerPivot table which shows the sales figures by week. The Pivot table is called Sales and the slicer is Slicer_Week.

The data come from an SQL server and when it gets refreshed, it automatically pulls all the information including the current week. My report only needs to show a week behind. So if we are in week 49 my Pivot table needs to show weeks 1-48. I have a week number which is calculated in cell A1. So when I open the workbook what I need to do is to look at cell A1 and whatever value is there then the slicer should automatically select Week1 to value of Cell A1-1, i.e. weeks 1-48 (if week no=49).
It be good if I can hide the other values in slicer so that user can only choose weeks 1-48 and not 49 (but this one is optional)
Will this be possible to do automatically?