Pivot Day wise data

[chiranjiv poojari]

Dear Team,

Need your help in Pivot ,

I had attached operation file sheet in which there are 3 column ( Invoice / Current Status / Actionable to )

I need to track team work Day wise how much they have work on these data and count has been reduced or increased

Below snapshot how i need a data in pivot .Can you help on this

 

[AlanSidman]

Since you have no dates in your raw data, how do you expect Excel or anyone to account for daily activity?

 

[chiranjiv poojari]

Hi,
You can add new column of date in my raw data ...All these data is for 24 July 2020 onwards ...


I need to track team daily work on these data from 24 July onwards

 

[AlanSidman]

No. I do not change your data. You supply the data that is representative of your actual files. This is not a case of me making up data or trying to see inside your head. If you want help here or on any forum, you must provide a realistic example of what your data looks like.

 

[chiranjiv poojari]

Hi,

Please find the update attached File with Date column.

 

[vletm]

chiranjiv poojari
... added Date-column

 

[chiranjiv poojari]

Thanks it really worked .....