Question

Percentage in Cross Tab

Rating7.1Very Good

I need help to define a report on calls data, for example how many calls connected (%), how many failed (%), Number of Total calls, Number of short calls (counting calls less than x seconds), Average Call, Average PDD (post dialing delay). This to be done for each service provider and for each country prefix. Since service providers can increase or decrease, so I need a dynamic CROSS-TAB solution. I heard this can be achieved in CROSS-TAB, if not possible it is okay to do without it, by question is how to make it dynamic?

I am attaching my report made in CR 2008 where I created all necessary formulas (though don't know how to get avg weight). I am only able to put total success and failure calls in cross tab. No idea how to add next to total failure/ success calls the Success%, Failure %, Total Short Calls, Weight avg duration, weight avg PDD grouped by tariff_prefix . As said above, if this can not be achieved how it can be done (appreciate my report is modified). I have also included datasource in excel.

Hope it would not big thing professionals like you. I am new in CR.

Thanks in advance.

 [embed=file 340751]
 [embed=file 340749]

  1. Cross Tab Average the sums calculated in a bott…
    I have a very striaght forward Cross tab. It is fo…
  2. Cross tab missing hours
    I use Crystal Reports x1, I want to create a cro…
  3. Cross-Tab headings
    I currently have a functioning cross tab that sum…
  4. Grouping in Cross Tab
    I need to group patient names in cross tab. A-F…
  5. Total calculation in cross tab
    I have to columns that are divided into one column…

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
Participating Experts
1
Solution Grade
B

Replies

 
by: NickHoward

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: NickHoward

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: mlmcc

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: NickHoward

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: NickHoward

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    345,774

    Wizard

    0 points yesterday

    Profile
  2. James0628

    76,896

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?