When the data i use is exported it loses the hierarchy that is set in the database and I am trying to reinstate that so that the data flows up and down properly. An example of what I have is below.
Hierarchy Group Order Number Cost Revenue
**** Header Group 123456 1000 2000
*** Sub Group 1 123456-01 600 1200
** Individual Order 1 123456-01-01 450 850
** Individual Order 2 123456-01-02 150 350
*** Sub Group 2 123456-02 400 800
** Individual Order 1 123456-02-01 350 700
** Individual Order 2 123456-02-02 50 100
Because of the way it is set up when i visualise it I get duplicated values since it pulls both the value for the Sub group and its individual orders, rather than having the individual orders as additonal data points. Is there any way I can transform it to actually gain back the heirarchy?
My End goal is to be able to have a Matrix where I can have: