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!!!
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!!!
