How can i get Sum and avg in Cross Tab report using Crystal report 11.

i am using Crystal report 11.
i have made one cross tab report. which is having Total column. that fine. but i need average as well. let me know how can i get Average value as well. for reference see my attached screen short.
cross-tab.bmp
mahmood66Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

joeywCommented:
I've never been able to work this out in the same cross tab.  When I've needed different looks at the same data, I've created an additional report section and added a second cross-tab with the other calculation that was needed.  
Mike McCrackenSenior ConsultantCommented:
What version of Crystal?

mlmcc
mahmood66Author Commented:
dear mlmcc, i am using crystal report 11 version, as i had mentioned in my first line.
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Mike McCrackenSenior ConsultantCommented:
Sorry, missed it.  I think what you want is a new feature in CR2008.  I don't believe you can do it in CR XI.

mlm
mahmood66Author Commented:
ok, i will check it out in crystal report 2008.
joeywCommented:
This is a little more work, but I have used this technique to create my own cross tab type report when I've needed more control and the column data is relatively stable.  In this method, you create variables for everything you want to track, add them to the group footer level and the report footer level for you grand totals.  For each varialbe you want to show, you will need to create three variables to reinitialize them at the start of each group.  This link describes what you will need to set up and in which section and this will work in any version of crystal.

http://www.crystalkeen.com/articles/crystalreports/runningtotalvar.htm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mahmood66Author Commented:
thanx for your support.
mahmood66Author Commented:
ok; noted:

1. below formula for Aluminium, same i have done for Brass and copper.
--In Detail section.
IF {Command.ItemGroup}='ALUMINIUM'  THEN
{Command.Quantity}

2. i have made the group date wise (month will display like Jan, feb)

Then i have calculate the sum of this formula. which will give me sum of that group.

3. To calculate the Average i have made 4 formulate for each column. e.g see below example for one of the column

Sum ({@F_Alu})/GroupNumber

Mike McCrackenSenior ConsultantCommented:
How does dividing by the GroupNumber give you the average?

You could use the Average summary function over the group

mlmcc
mahmood66Author Commented:
I got some knowledge and partially solved my issue.i have done it with  a work arround.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.