AnsweredAssumed Answered

Sub-Summary

Question asked by weirdough on Oct 15, 2018
Latest reply on Oct 17, 2018 by sccardais

I'm trying to perform a reporting of online sales via sub-summary but to no avail.

 

I have 3 tables:

Transaction table - main table to store order details

Ticket table - a transaction may consist of 0 or more tickets.

Concessions table - a transaction may consist of 0 or more concession items

 

TRANSACTION

__PK_OrderID

Order_Reference

Transaction_Timestamp

Total_Order_Value

 

TICKET

__PK_TicketID

_fk_OrderID

T_Description

T_Seat_Location

T_Price

 

CONCESSIONS

__PK_ConcessionID

_fk_OrderID

C_Description

C_Price

C_Quantity

 

I can't seem to perform a sub-summary to display the above information correctly.

Below is my setup:

Order_Reference | Total_Order_Value | Transaction_TimeStamp (sub-summary sorted by __PK_OrderID)

T_Description | T_Seat_Location | T_Price (sub-summary sorted by __PK_TicketID)

C_Description | C_Price | C_Quantity (sub-summary sorted by __PK_ConcessionID)

 

Note: a transaction will have one of the following attributes:

Tickets only, no concessions

Tickets with concessions

Concessions only, no tickets

 

Thanks in advance.

Outcomes