3 Replies Latest reply: Jun 19, 2015 12:34 AM by Settu Periyasamy RSS

    How to display data dynamically?

      Hi,

       

      I create pivot table.and I want to display data dynamically but I do not

      know  how to display dynamically .pls tell me out how to display data  dynamically in pivot table  like this .If I select Jan in  list box then pivot table show Jan data.If i select Feb in listbox then  my Pivot table show jan and Feb Data.and If I select March In list box then My pivot table show Jan,Feb,March .

      This is my data

      LOAD Id,

           CarName,

           Price

      FROM

      [D:\madhu\Data\Bundle1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

      car:

      LOAD

      Month(Date#(RecNo(),'M')) as Month

      AutoGenerate 12;

       

      Here when I select Feb It dispaly only feb data but I want to display data like this  when i select feb It dispaly Jan and feb data.If i select

      Mar then pivot table display jan,feb,mar data.

       

      500.PNG

       

                                                                                            Thankyou,

       

      Regards

      madhu