Need help on application design

[guillaume_gorli]

Dear All,

Please see below the issue i am facing :

I have a sales database showing basic data :

• Invoicing date
• Part number
• Desc
• Customer
• Qty
• Cost
• Total Cost
• Selling price
• Whole Goods reference
• Type

This database includes whole goods part numbers as well as part numbers invoiced to the customer by repair center.

For instance customer Robsinon purchased part number 0001X000 on 01/01/2017. This part number is declared as a whole goods thanks to the field Type (which is "Whole goods"). Some days later other references have been sold to this customer to be mounted on the whole goods initially sold. The key that links all this is the field "Whole Goods reference" :

The target of the application i have to build is to sum up those warranty cost per part number but also per whole goods.

To sum warranty cost up per part number is easy :

To sum warranty cost per machine is ok as well.

The issue i am facing is that in the last table i have to show data linked to the whole goods (Description of the whole goods, invoicing date of the whole goods & customer) although the total cost column is linked to the components invoiced by repair center.

So the output i get is the following : the description and the invoicing date refers to the components sold and not the whole good.

Although what i should get is :

I attached qvw and excel test database for the ones who could help.

Thanks in advance

Guillaume

[techvarun]

Hi,

Kindly check the attached sollution feasible.

[Anil_Babu_Samineni · Accepted solution]

This?

Sum(Aggr(Sum ({$ <[Type]={'Repair Center'}>}[Total Cost]), [Whole Goods reference]))

[Anil_Babu_Samineni]

And please check the suppress from presentation

[guillaume_gorli]

Thanks a lot !