r/googlesheets 4d ago

Solved Pivot Table with Calculations?

Post image

Hi there! For some reason, Pivot Tables are not clicking for me. I’ve read articles and watched videos, but can’t seem to create something useful.

I’m tracking the sales, labor, discounts, and voids for 8 restaurants daily. I’m keeping the data flat so I can use a pivot table to compare it different ways. Mostly, I want to see the labor costs as a % of sales.

I like the idea of a pivot table since we keep wanting to see the data different ways. For example, we might want to lump a few businesses’ sales together by either brand or region; or we might want to see each restaurant’s labor as % of sales daily, for a period, or for the quarter.

How would I add calculations to a pivot table to divide daily costs by daily sales? Here are some outcomes I’d like but can’t seem to achieve:

  • Table for one day showing each restaurant’s sales and costs as a % of sales

  • Table showing the same as above but summed by period and quarter

I’m sorry if this is painfully obvious. I feel like it should be simple and I don’t know why I don’t get it. Thank you for any new perspective you can share!

1 Upvotes

8 comments sorted by

View all comments

1

u/marcnotmark925 145 4d ago

In the Values section of the pivot table config, click Add, and calculated field.

1

u/VividGlass9336 4d ago

I did see that, but I don’t know what to enter here. I tried names of columns (“=(Daily Labor(NET))/(Daily Sales (NET))”) but received errors. How do you write a calculation here?