Summary in a report

[sajarac]

Hello guys, hope someone can help me with this question:

I would like to add a summary table at the end of my report, currently I have some fields like Door type, Door size, door color. And the possible choices are like follow:

Door Type:
Double
Single
Other

Door Size:
3 x 7
3 x 8
3 x10

Door Color
Mill
Brown
White

What I like to achieve is a summary table that represent:

................Sizes.........................Door Colour
Doors.........3x7...3x8...3x10..........M...B...W
Singles........10.....15.....18............25..18
Doubles.......7.......3.......1.............11
Other..........1.......2.......0..............3


Thanks in advance for any advice

Regards

Sajarac

 

[sajarac]

Thank you very much for your prompt reply, please see the enclosed file and please let me know if this is possible.

Regards

Sajarac