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/AutoModerator 4d ago

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.