Show Sum of group as a repeated line item!

StarCat

New Member
Joined
Oct 8, 2011
Messages
3
Here is my data:

Code NA1 NA2 Share NA3 Totals

A x x 1 x 16
A x x 10 x 16
B x x 5 x 8
A x x 5 x 16
C x x 7 x 7
B x x 3 x 8


....Only, my "Totals" field is not working. I don't want a pivot table, because I want the total sum of all the Shares (1, 8) repeated on the same row for the relevant Code (A, B, C), where there is an infinite number of Codes.

Can anyone help? I have been looking for too long and mostly I find data ranges instead of specifics for my Code values.

For further clarification, the Code is a song, and Shares represent a portion of the song owned by NA2. On each line, I need to know if we have enough shares to represent 100% of the songs' ownership.

Thankyou!!!
 

Forum statistics

Threads
1,082,587
Messages
5,366,486
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top