G
Guest
Original data:
Vendor Type Amt
Vend A Stationery 1
Vend A Stationery 2
Vend A Welfare 3
Vend A Fixture 1
Vend B Stationery 3
Vend B Stationery 2
Vend B Fixture 1
Vend B Fixture 2
Required to get (1) Individual Vendor Total and (2) Individual Type Total
Question: How to achieve the following result using Subtotal?
Vendor Type Amt
Vend A Stationery 1
Vend A Stationery 2
Stationery Total 3
Vend A Welfare 3
Welfare Total 3
Vend A Fixture 1
Fixture Total 1
Vend A Total 13
Vend B Stationery 3
Vend B Stationery 2
Stationery Total 5
Vend B Fixture 1
Vend B Fixture 2
Fixture Total 3
Vend B Total 16
Grand Total 30
Vendor Type Amt
Vend A Stationery 1
Vend A Stationery 2
Vend A Welfare 3
Vend A Fixture 1
Vend B Stationery 3
Vend B Stationery 2
Vend B Fixture 1
Vend B Fixture 2
Required to get (1) Individual Vendor Total and (2) Individual Type Total
Question: How to achieve the following result using Subtotal?
Vendor Type Amt
Vend A Stationery 1
Vend A Stationery 2
Stationery Total 3
Vend A Welfare 3
Welfare Total 3
Vend A Fixture 1
Fixture Total 1
Vend A Total 13
Vend B Stationery 3
Vend B Stationery 2
Stationery Total 5
Vend B Fixture 1
Vend B Fixture 2
Fixture Total 3
Vend B Total 16
Grand Total 30