I've been given a data set that consists of hundreds of Stores and almost a hundred dates, below is a small sample. The issue is that dates (mmm-yy) are actually heading names. The reason I see this as an issue is that whenever a new month is made available, the column heading will need to be dragged down to the Values section of the pivot table. Also, I am unable to use a slicer or timeline range to control which months I want to show data for. How can I get around this issue?
