Best way of Establising Percentages in Cross Bar using Report Author 10.1.2

[gosoccer]

Folks,
I have the following and I'm trying to see what it the best way to establish PCT calculation for Success and Failure by turning
the Query - Automatic Group and Summary Off since this option causes major slowness.

yes. using the total in Aggr. Func. did the trick thanks for Paul's recommendations, but now, I am trying to see what's best for the percentages.

Currently, I have

when [BUSINESS_VIEW].[SuccessUserCertRequest].[TARGET]
='home-phone-number' then
[BUSINESS_VIEW].[SuccessUserCertRequest].[HomePhoneFailureCount]/[Total_All]*100
with Aggreg. Func set to Total. I'm getting weird results.

Action                         || Success || Success% || Failure || Failure % || Total

'home-phone-number'        2                               5                             7

What is the best setting to calculate the Success% or Failure %.

That is all I need.

Thx so much for your time.