Automate Date field in pivot table using macro RRS feed

  • General discussion

  • Hi,

    I have an Excel sheet consisting of Pivot table and it has Date field with name "AsAtDate" coming from SSAS 2000 dimension, I need  to write a Macro which automatically select the Date field of Pivot table in excel to 2 days prior to today's date. Appreciate the early response, thanks in advance...

    • Changed type qadir756 Wednesday, December 21, 2011 5:45 AM It would not come under Fix it centre
    Wednesday, December 21, 2011 4:56 AM