Getting ratio of two totaled columns in sas Visual anlaytics 7.3 crosstab

[Thilan]

Need to get the ratio from two total columns instead it sums up the whole ratios. The ratio of the total column should be something like (Os Balance Total/ No of accounts) TOTAL *100. Instead I'm getting the sum of all ratios as the total.  The problem containing cells are highlighted in yellow. Please help me in finding a way to get the ratio of two totaled columns.

[PetriRoine]

Hello @Thilan 

I believe you need to use aggregated operators in calculation i.e. Sum [_ByGroup_] ({Number}).

Best regards,

Petri