Hello listers.
I have a table as follows.
I’ve used Ranking to display only the top 3 Companies based of sales volume.
I need to display the percentage based on the sum of Sales
of all Companies NOT just the total of A,B and C in the table.
How do I do that?!
Company Sales %of Grand Total
Listserv Archives (BOB member since 2002-06-25)
In a message dated 99-04-02 11:03:34 EST, you write:
I have a table as follows.
I’ve used Ranking to display only the top 3 Companies based of sales
volume.
I need to display the percentage based on the sum of Sales
of all Companies NOT just the total of A,B and C in the table.
How do I do that?!
Check out the “Best vs. Rest” Report example on our web site. It should
provide some ideas on how to accomplish this!
URL: http://www.islink.com/bestrest.htm
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
Dave,
thanks a lot,
but
I still cannot make the percentage column to work!
My Subtotal, the Rest and GrandTotal are fine.
In my formula I put ‘=(/)*100’
but I get as a result 100 (in my percentage cells).
Any more hints?
Thanks again
ioannis.
DRathbun@AOL.COM 04/02 12:00 PM >>>
In a message dated 99-04-02 11:03:34 EST, you write:
I have a table as follows.
I’ve used Ranking to display only the top 3 Companies based of sales
volume.
I need to display the percentage based on the sum of Sales
of all Companies NOT just the total of A,B and C in the table.
How do I do that?!
Check out the “Best vs. Rest” Report example on our web site. It should
provide some ideas on how to accomplish this!
URL: http://www.islink.com/bestrest.htm
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
In a message dated 99-04-02 14:41:49 EST, you write:
Dave,
thanks a lot,
but
I still cannot make the percentage column to work!My Subtotal, the Rest and GrandTotal are fine.
In my formula I put ‘=(/)*100’
but I get as a result 100 (in my percentage cells).Any more hints?
I need to see the formulas for the variables and before
I can make any more suggestions. But, as mentioned in the sample report, you
have to use the NoFilter() function to get the overall total.
Without using variables, the net formula should be something like:
/ NoFilter( In Report)
Instead of using * 100, just leave the number as a decimal and format it as a
percentage.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
Ioannis,
Try adding a NoFilter to the % of Grand Total field.
For example:
=/NoFilter(Sum()) ForAll
You can apply the “Nofilter” before or after the ranking. Just
click on the percentage field to highlight the data.
Modify the formula in the formula toolbar or right-click
on the column and choose edit formula…
Thanks,
Jeff Moore
Systems Engineer
Electronic Data Systems
Listserv Archives (BOB member since 2002-06-25)
Hi:
Try
= / NoFilter( In Report).
The numerator in this case returns the sum of the volume that is displayed
in the report. The denominator returns all of the sum of the volume in the
data that the query has retrieved.
Robert Schmidt
Schmidt Interactive Software, Inc.
Listserv Archives (BOB member since 2002-06-25)