I've been looking for this for so long it's ridiculous... I've always wanted to be able to simply use a slicer to change the row values on my pivot tables/charts from Year to Quarter to Month without needing multiple tables/charts.
This guy is brilliant and very kind to share with all of us. Please check his article. It's awesome.
Oh man, my job is so much easier now... :)
