Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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"?
Thx for your help.
The second table is fairly simple
Hi Christian,
look in the Attached if this helps.
One table is without customer_name as Dimension and one is made in script
Is this what you are trying to get?
Hi both,
thanks a lot, this is getting in the right direction.
@Sunny, I would like to have a second table with just the Dimension Entry"All Customers", is this also possible with your approach?
The second table is fairly simple
That's too easy, I can't imagine this is working... my fault.
Thank you so much!