Sum of some lines at pivot table (grouping not working)

[ccastaldi]

I'm trying to sum some of these lines, putting them together, but excel doenst allow me.
For instance, sum the 3 first lines (have them individualy, and a subtotal for them).
I've already tried to group them, but it didn't work.

Does anyone know how to do it?

thank you in advance

 

[Alex Blakenburg]

What happened when you tried to group them ?

 

[ccastaldi]

What happened when you tried to group them ?

View attachment 101752

The message above appears (it was not possible to group the selection)

 

[RoryA]

Which cells did you actually have selected when you tried to group?

 

[ccastaldi]

Which cells did you actually have selected when you tried to group?

first 3 rows
(I also tried first 3 cells, and didn't work as well)

 

[Alex Blakenburg]

Are you using a normal pivot or Power Pivot ?
How are you generating the % column (what settings are you using) ?
It seems to be unusual for it to not have a Grand Total.

 

[ccastaldi]

Are you using a normal pivot or Power Pivot ?
How are you generating the % column (what settings are you using) ?
It seems to be unusual for it to not have a Grand Total.

Normal Pivot table.
I have removed Grand total.

I have generated % column using pivot table's feature (% of one of the variables).
I have also removed the % column and tried again. It didn't work.

 

[Alex Blakenburg]

I have removed Grand total.

How did you remove the Grand total from the % column and not the amount column ? I can't replicate that.

Do you have more than one pivot off the same data set ?
And do any of the pivot tables using that data set have calculated fields ?

 

[ccastaldi]

How did you remove the Grand total from the % column and not the amount column ? I can't replicate that.

Do you have more than one pivot off the same data set ?
And do any of the pivot tables using that data set have calculated fields ?

I have no ideia why, but I have generated a new pivot table and now its working.

 

[Alex Blakenburg]

Thanks for letting us know. Glad you were able to get it working.