I am having several Customer which are producing Revenue and I would like to see the split of the different revenue sorts for each customer in a first table.
But I would like to have a split between these revenues also for a "Total Customer" line, in a second table.
I have made a sample and also added the wished outcome as Excel Screenshot. Can somebody ´please give me a tip how to achieve this in QlikView? Do I have to load my complete twice, but the second time with the Customer Name "Total"?