OK, New But VERY similar.
I know need to show how many changes occurred on Non Refundable tickets and Refundable tickets, following is how data is seen.
Group 1 ABC
Group 2 BAAAME NON REFUNDABLE
Detail 132456 640.20 NR 1 0
BAAADG NON REFUNDABLE
123654 246.04 NR 1 0
CDEFJJ REFUNDABLE
987589 1.00 R 0 1
987591 123.00 PX 0 1
UEIRRU NON REFUNDABLE
458796 711.54 NR 1 0
987541 336.27 PX 1 0
Ok, the PX represents a "CHANGE" ticket, so I need to first see how many changes occur at the group 2 level then i need to see it at the group 1 level, end result should look like...
Div Name 5 3 1 1 1
Total Rec NR Rec NRP Rec R Rec RP Rec
I know need to show how many changes occurred on Non Refundable tickets and Refundable tickets, following is how data is seen.
Group 1 ABC
Group 2 BAAAME NON REFUNDABLE
Detail 132456 640.20 NR 1 0
BAAADG NON REFUNDABLE
123654 246.04 NR 1 0
CDEFJJ REFUNDABLE
987589 1.00 R 0 1
987591 123.00 PX 0 1
UEIRRU NON REFUNDABLE
458796 711.54 NR 1 0
987541 336.27 PX 1 0
Ok, the PX represents a "CHANGE" ticket, so I need to first see how many changes occur at the group 2 level then i need to see it at the group 1 level, end result should look like...
Div Name 5 3 1 1 1
Total Rec NR Rec NRP Rec R Rec RP Rec