Forum Discussion

Deleted's avatar
Deleted
Apr 05, 2018
Solved

Pivot table to take data for latest date

Hi,   I need help with creating pivot table with attached excel. (actual sheet has more than 1000 rows, attached sheet is just sample data) For InputFile, I have to consider data for latest dat...
excel
Formulas and Functions
  • Jaroslaw Szczygielski's avatar
    Jaroslaw Szczygielski
    Apr 06, 2018

    Hi,

     

    That kind of does what you want, but I had to convert CVS to excel format.

    You'll probably need to tweak it to work flexibly.

     

     

    Regards, Jarek

Jaroslaw Szczygielski's avatar
Jaroslaw Szczygielski
Copper Contributor
Apr 06, 2018

Hi,

 

That kind of does what you want, but I had to convert CVS to excel format.

You'll probably need to tweak it to work flexibly.

 

 

Regards, Jarek

  • Deleted's avatar
    Deleted
    Apr 06, 2018

    Thanks! I will check this :)

Resources