Calculate a value using the "Partial Sums" from Pivot Table

[#1]

Hi,

I've been facing an issue when trying to get a calculated value. What I want is to calculate the percentage of each 'Num' in the 'Total'. Meaning, if we select the 'CARRCD'=DY, I wanted the following value to be presented in another column, (10/40)*100 .

In order to calculate the field 'Num' I've used the formula

sum(aggr($(vNumTickets),CustomerName1, CARRCD))

so that it's possible to present the total sum of the field 'Num' when selecting the option 'Show Partial Sums' for the field 'CustomerName1'.

Since the Total is an information we get from the PIVOT Table, how can I perform that division using the value provided by the TOTAL?

Thank you very much for your time.

Mariana

[#2]

Does anyone has any tips?

Thanks in advance.

Regards,

Mariana

[pablolabbe]

sum(aggr($(vNumTickets),CustomerName1, CARRCD)) / sum(TOTAL aggr($(vNumTickets),CustomerName1, CARRCD))