How to use AGGR on a Cyclic Group

[#1]

I'm trying to do a total in a pivot table, uisng the AGGR function, because thet normal subtotal will not work, however a cycle the Pivot table with a Cylce group. How should aI fill the condition for the AGGR function? I cannot select the group name?

[lironbaram]

hei

attach is example of what you asked for

hope, its helps you

[#3]

Thanks a lot, that was of great help.