Subtotals in Reports

M

Mavig

I am trying to count the the total numbers of records with in a grouping. I
am grouping on Labels and then artist with in Labels. I subtotal for each
artist, now I want to subtotal all the artist records under the label. So
say I have 3 artist listed under a Label, each Artist has 3 songs. At the
label grouping I want it to total to 9.

Thanks
 
M

Mavig

I am but it only counts the 3 different artist not the records in each - so
it only counts to three, I want is to count the total for the 3 artist
 
K

Klatuu

Maybe you don't have it set up quite correctly.
Your sorting and grouping should be
Label
Artist

Then you should have a group footer for each. Be sure you do your count on
the same field for each level.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top