Group Data by columns contents

[Valnus]

Hallo 

I have two colums in below 

I need to create a group by category and grade ( content and not the colums) 

For example : 

Artisan T07 or Technician T11  

I will then apply my calcualted usage to each of these and it will show what Category and grade has the usage. 

Instead of creating calculated tables for each group I need ( 16 in total ) is there another way ? 

Grade	Category
M18	Managerial
M18	Managerial
M16	Managerial
M18	Managerial
M18	Managerial
P18	Managerial
T06	Tech Non-Sup
T05	Non-Tech Non-Sup
T09	Non-Tech Non-Sup
EEE	Executives
T09	Non-Tech Non-Sup
T09	Tech Non-Sup
M15	Managerial
T12	Non-Tech Non-Sup
T10	Non-Tech Non-Sup
T10	Non-Tech Non-Sup
F Band	Executives

[amitchandak]

@Valnus , The information you have provided is not making the problem clear to me. Can you please explain with an example?

Appreciate your Kudos.

[Valnus]

Hi 

Ok so inside the two colums is information I need to group ( Combine Managerial & M18)  and report on 

So le't's say  Managerial M18 is one group and Managerial M16 is another. 

The amount of people I have will each contribute to the total of the above groups. 

So Managerial M18 = 10 & Managerial M16 = 20 

I have 16 of these groupings that I need to display 

If my total people is 30 ( I have the measure so don't worry about that )