We have dataset of Sales of different branches of a chain store

Pivot Tables can be used to summarize data for example sum of sales for the stores in each city.

The store number also may be used in conjunction with the city as row label.

Another dimension such as Date may be added to the table as columns.