Grouping & Subtotals 1

[southbean]

Hello All,

I need to create two groups:
1. A group by Type
2. A group that lists each person and total the number of days they stayed at a particular hotel.

Data Sample Below:

Name Hotel Type Date Rate
Haskle, Eddy ACME Type 1 01/01/2008 100.00
Haskle, Eddy ACME Type 1 01/02/2008 100.00
Haskle, Eddy ACME Type 1 01/03/2008 100.00
Haskle, Eddy ACME Type 1 01/04/2008 100.00
Cleaver, June ACME Type 1 01/01/2008 100.00
Cleaver, June ACME Type 1 01/02/2008 100.00
Cleaver, June ACME Type 1 01/03/2008 100.00
Cleaver, June ACME Type 1 01/04/2008 100.00
Cleaver, June General Type 1 01/05/2008 125.00
Cleaver, June General Type 1 01/06/2008 125.00
Cleaver, June General Type 1 01/07/2008 125.00
Cleaver, June Standard Type 2 01/08/2008 300.00



REPORT SAMPLE OUTPUT

Type 1 Hotel
Name Hotel Type # of Days Rate Total
Cleaver, June ACME Type 1 4 100.00 400.00
Cleaver, June General Type 1 3 125.00 375.00
Haskle, Eddy ACME Type 1 4 100.00 400.00

Type 2 Hotel
Name Hotel Type # of Days Rate Total
Cleaver, June General Type 2 1 300.00 300.00

Any/all help suggestions would be greatly appreciated!

-tl

 

[lbass]

Insert groups in this order: Type, Name, Hotel. Then insert a distinctcount on the date, and a sum on the costs at the Hotel group level.

-LB

 

[southbean]

LB,

Perfect! Thank you!!

I don't know whay I couldn't get my head around that one. You, obviously, saw it more clearly than I did.

Thank you again!!!

- TL