Pivot table vs Microsoft excel

[#1]

in pivot table, used dimention is main_category which list boys,girls,and men

and sub_category which list boy1,boy2,boy3,girl1,girl2,men1,men2,and men3

On expressinon i have sum(score)

Is the any way that i can calculate the sum(score) of boys/girls in pivot table ?

Check my attached file for better explanation.

I will highly appreciate your help!

[#2]

It appears as though you are trying to add a subtotal for the "boy/girl" category and a separate one for the "men" category

I'd recomend structuring your data to allow sub-totaling by Boys/Girls and by Men/Women. I've attached a qvw with my suggestion

[#3]

in your attached file i want that subtotal for boy/girl to appear in 1 chat not on different chat. what can i do?