I need to parse a sheet for a restaurant, I’m imputting the data for each order each waiter got, and need the sum of the orders for each waiter.
Hallo
Click some Cell in the First Column
→→Data→→Pivottable→create Pivottable…
Thank you very much, would it be possible to also already get a sum of the rows? Next to the Sum of Bianco
In the Pivot Table Layout dialogue, expand Options and then tick the box Total rows
Hallo
In the Source-sheet right of »Bianco« enter »TOTAL« and in the cell below »TOTAL« calculate the Sum of the Row:
=SUM(B2:F2) #probably
pull down
in the Pivot-dialog →→Options→change the Sourcerange and drag&drop »TOTAL« into Data-field
if you have no need for the individual sums, you may drag&drop the entrys out of Data-fields
Doesnt work in that case because each of the Data-fields is its own Label.
Pefect thank you, I have multiple days, but they are few so I’m just gonna do a manual total sum for each waiter and each day at the end. Thank you very much again.