Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table which displays dollars by product(down) and year/month(across).
The requirement is to be able to look at dollars across 2 non continious time periods.
Example : The pivot table by default shows data for all months across 2 years. say Jan Feb Mar April May.. 2011 and Jan Feb Mar April May..2012
Is it possible to have a slider that will allow me to select Jan Feb Mar in 2011 and Jan Feb Mar in 2012. and no other time periods.
Does the attached sample application meet your requirements?
Thank you so much Krishnamoorthy. Looks like this will meet the requirements i'm looking for.