Is there a better way to summarize tables compared to 'group by'?

[PBInonpro]

I have a finance table for budgets and estaimtes and it has several categorical features/columns. There has to be a better way to summarize the table and utilizing the features for lookup tables rather than creating each indiviual table via 'group by' in transform. 

Example table:

LOCATION	OFFICE	TYPE	COLOR	ESTIMATE	BUDGET
NORTH	A1	BIG	BLUE	15	16
SOUTH	A1	SMALL	BLUE	20	22
NORTH	A2	SMALL	BLUE	18	17
NORTH	A1	SMALL	BLUE	19	23
SOUTH	A1	BIG	GREEN	15	20
SOUTH	A3	BIG	GREEN	21	14

Based on this table, i would go to transform and create a table via group by for each 'location', office, type and color. 

Then these tables are used for reference in dimension tables. Example, another database might have total revenue for North or total costs for Small. 

[ppm1]

There shouldn't be a need to create all those summary tables. You should be able to just keep all the detail and create your summaries in visuals and/or measures. Please clarify what you are trying to do. Sample data with expected outcome is always helpful to get a specific answer from the community.

Pat