Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-09-05 10:35 AM

Link Parent Order to Sub Orders and Sum Total Order amount

Hi,

Please can someone advise?

I have an Order which consists of a Parent Package Part and Sub component parts associated to the same Order no e.g.

Untitled.png

A Packaged Part can also consist of more than one order e.g.

Untitled2.png

What I want to be able to do is calculate the Sales and Gross Profit for Part No: C11245-10B Set A across the above 4 orders.

The Problem I have is that the Sales Revenue and CoS is calculated at the component part level and not at the Package part level. Therefor when I select the Part No: C11245-10B Set A I can see the 4 orders that are associated with that part but non of the components or costs associated underneath the Package part.

Any help/advice very welcome?

Thanks,

Nikki

243 Views
0 Likes
0 Replies