Hi

This is my current Worksheet.
Excel1.png

I need to insert a pivot table such that the data can be displayed by NAME or by ITEM for all the dates, with automated sum for each.
When i try to create a Pivot selecting the entire table, I get an error saying "Pivot table field is not valid". I am not sure how to proceed. Can anyone help me out?

Thanks in advance