Generating one additional Total Entry in Field

[chriys1337]

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.

[stabben23]

Hi Christian,

look in the Attached if this helps.

One table is without customer_name as Dimension and one is made in script

[sunny_talwar]

Is this what you are trying to get?

[chriys1337]

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?

[sunny_talwar · Accepted solution]

The second table is fairly simple

[chriys1337]

That's too easy, I can't imagine this is working... my fault.

Thank you so much!