Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

column percentage in grand total?

Status
Not open for further replies.
sagobogger

sagobogger

Technical User
Jun 18, 2004
69
US
I have a report with 8 data columns and a row-total column. Can I get two grand total lines, first the regular totals, and second the % that each column is of the row total? Something like:

Code: 
100   50   120   75   175   130   200   150   1000
10%   5%   12%  7.5% 17.5%   13%  20%   15%   100%
 
Sort by date Sort by votes
RPCT. works fine for the individual rows, but the total line just adds them up, maybe I need to do a recompute or something...
 
Upvote 0 Downvote
sagobogger

I believe you have the solution...

Issue a RECOMPUTE for the Total Line.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Jack3d
  • Locked
  • Question
rows into column grouped by same ID
Replies
2
Views
158
Jack3d
Jack3d
LeonelSanchezJr
  • Locked
  • Question
Recompute and AVE Column
Replies
0
Views
63
LeonelSanchezJr
LeonelSanchezJr
ekl0908
  • Locked
  • Question
Can I create a JOIN which uses two different keys depending on a field in the file?
Replies
0
Views
106
ekl0908
ekl0908
amarg
  • Locked
  • Question
Rounding in webfocus
Replies
2
Views
151
amarg
amarg
LeonelSanchezJr
  • Locked
  • Question
Resize IFrame Using JavaScript in WebFOCUS 7.6.7
Replies
0
Views
67
LeonelSanchezJr
LeonelSanchezJr

Part and Inventory Search

Sponsor

Back
Top