How do I get the correct order for nested subtotals

C

cyn

Subtotal 1:Data,subtotal,vendor. Subtotal 2:Data, subtotal, month. Why does
the last subtotal for month appear AFTER the subtotal for Vendor? See below.

Month Vendor Srce Amount
1 A147 APIN 116.44
2 A147 APIN 2.15
2 A147 APIN 0.19
2 A147 APIN 13.94
2 A147 APIN 1.08
2 A147 APIN 119.66
2 A147 APIN 0.56
2 A147 APIN 0.14
2 A147 APIN 38.64
2 Total 292.80
7 A147 APIN 217.94
7 A147 APIN 3.43
7 A147 APIN 0.20
7 A147 APIN 24.88
7 A147 APIN 3.55
A147 Total 542.80
7 Total 250.00
 

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

Similar Threads

How do I export subtotals from an Access table to Excel? 1
How do I retrieve data based on multiple search criteria? 0
How do I nesting subtotal function within average function in Exc 4
How do I get a column to "auto fill" in a pivot table? 2
How do I get total hours from 2 date/time cells? 4

Top