Excel Pivot Data from MS SQL cube Challenge

    I need help, I want to filter date range of a Pivot table data from cube using begin date and end date field field in excel. I have tried some VBA code but no success. kindly help The data is in this format thank you.


    [TABLE="width: 576"]

    [tr]


    [TD="class: xl65, width: 64"] [/TD]
    [TD="class: xl65, width: 64"]ergfg[/TD]
    [TD="class: xl65, width: 64"]ad[/TD]
    [TD="class: xl65, width: 64"]gh[/TD]
    [TD="class: xl65, width: 64"]jk[/TD]
    [TD="class: xl65, width: 64"]kl[/TD]
    [TD="class: xl65, width: 64"]pl[/TD]
    [TD="class: xl65, width: 64"]yu[/TD]
    [TD="class: xl65, width: 64"]ty[/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Dec-2009[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]6[/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Jan-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Feb-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]4[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Mar-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]5[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]4[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Apr-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]May-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Jun-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]6[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Jul-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Aug-2010[/TD]
    [TD="class: xl65, align: right"]0[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Sep-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Oct-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Nov-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Dec-2010[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]7[/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Jan-2011[/TD]
    [TD="class: xl65, align: right"]1[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]2[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Feb-2011[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Mar-2011[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Apr-2011[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]May-2011[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]0[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65, align: right"]9[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]Jun-2011[/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]
    [TD="class: xl65"] [/TD]

    [/tr]


    [/TABLE]


    Thank you guys

    Re: Excel Pivot Data from MS SQL cube Challenge


    please post the code what have you done so far and also attach a workbook with the data so that its easier for people to solve it more efficiently.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login