Calculated Totals : % of sub totals

[jollt]

Hi, Is there any possibility to have a column which calculate automaticaly the percentage of the value regarding the sub-total and not the global total.

for exemple :

Stat Renouvellement Polices2

Code: Select all

Country          Policy Status              Policy number Caculated totals
Afrique du Sud                                                           
                 1. Polices non renouvelées  1                  0%
                 2. Polices Renouvelées      2                  0%
                 Total (Afrique du Sud)      3                  0%

Algerie
                 2. Polices Renouvelées      19                 3%
                 Total (Algerie)             19                 3%
 
etc...


I need the calculated total to be 33.33% and 66.66% for the group Afrique du sud and 100% for the group Algeria. The values shown are percentage of the global total.
Thanks,

Jérôme

[Carsten Sørensen]

Hi,

If you group the Policy Status in Columns and change the % calculation to calculate as "% of Row" you should get the percent of the sub-totals.

Best regards,
Carsten

[jollt]

It's working, i missed the group in column option.

Thanks a lot

Best regards,
Jérôme

[admin]

I had not seen that Carsten had already responded, so I made a video clip to show how - maybe others can benefit:

http://support.dynamicai.com/images/screenshots/boa/SubtotalPercent.swf

Best regards
Bo

[jollt]

Thanks Bo