4 Replies Latest reply: Dec 3, 2015 1:31 PM by Enrique Colomer RSS


      Hi all,

      I have a visualization problem, I think.

      I have 4 table:

      1) Final Product

      2) Bill of Material

      3) Product

      4) Cost


      Each table include reference to his master (the number 1 is the major and number 4 is last child).

      I need to have for each Final Product the cost represented as

      Product.quantity * Cost.price


      When I use a Qlick Table I can see the right result for each Product in BoM. But when I convert in Pivt Table, rows disappear, like it could not manage sum without explode ...


      I hope you can help me (and also understand the problem!)


      In attach the piece of DB view and the table showing rows correctly calculated ...


      Thanks in advance


      Messaggio modificato da Natale Zaramella BOM is the right example, but I find it difficult: I do not have an hierarchy... I attach an example with the two graph, the pable that shows results and the pivot that does not ... I can't understand why pivot is not showing results ...