Sum, aggr and total

Hi everyone!

I have the next data:

type  transactions  client      type2

1           3              name1     123

2           4              name2     234

3          11              name3     345

1           4               name4    133

......

There are a lot of types.

I create a pivot table with the dimension type and, for each one, i created a calculated dimension:

=IF(

      aggr(

             rank(

                    SUM(

                             {<

                                 type2 = {'1*'}

                              >}

                              transactions

                            )

                     ),type, client) <= 10,

  client)

this bring to me the top ten client with the maximun transactions (in the expression I sum the transactions where type2 = {'1*'})

This is ok, but, i need another expression that sum all the transactions grouped by type (for the example data for the type 1 the sum is 7), i try with aggr, sum and total but it doesnt work.

Thanks a lot!!

Upload example!