thank you so much! This is exactly what I Need. I now understand the data Format I have to feed into Qlik to reach this result. Unfortunately I still do not understand how to use the load function in the Syntax. I checked your code and it seems to me you typed every agrument manually....which surely is not the case:
CrossTable(Cost_Type, Cost, 2)
LOAD * INLINE [
Part name , Vendor , Material Price , Production Cost , Overhead, Margin
Coffe bin, A, 11, 5, 2, 3
Glass, B, 12, 6, 1, 4
Spoon, C, 13, 3, 1, 2
Plate, D, 11, 4, 1, 5
Knife, E, 12, 7, 2, 2
In this code you already refer to new Collum designations as Cost_Type. I still do not see where those are introduced and linked to the original table.
The help until here is already highly aprreciated! If you can give me further hints I would be very happy!
Thank you so much!