If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[Solved] % or total

Started by theroc, 20 Sep 2005 02:01:16 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

theroc

20 Sep 2005 02:01:16 PM Last Edit: 21 Sep 2005 06:59:54 AM by ReportNet Addict
I have a report that has order counts in two groupings I would like to get a % of the each group based off the total, I am struggling with this can anyone help example:

Busness lineÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, Order SourceÃ,  Ã,  Ã,  Ã,  Ã,  # of ordersÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, % of total
ShirtsÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  webÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  10Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 50%
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  catalogÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 10Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  50%
totalÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  20

any help would be great......

sir_jeroen

#1
20 Sep 2005 03:37:25 PM Last Edit: 21 Sep 2005 05:42:11 AM by ReportNet Addict
This will make it clear i think.

Visit the tutorial @: http://jeroendegraaff.nl/tutorials/

Let me know if it was of some use for you

Good luck
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite