Thank you for youre response.
Customer 10 has 100.000 in revenue.
Manufactor EB produces 1.000 and BT produces 2.000 to customer 10.
I want qlikview to show for EB ((100.000/3000)*1000 =33.333 and for BT ((100.000/3000)*2000 =66.667
In the 3.table TO THE RIGHT Qlikview only shows BT and they get all revenue, EB gets NUll. FOR CUSTOMER 10.
I want to show Production share of the revenue by manufactor.
Hope it helps to understand.
hi the problem you have is due to your data structere
the simple solution is to have to seperate tables
one for production and one for sales
have a look at the attach document
testtotal (1).qvw 156.5 K
Thank you for youre answer my problem is that my original document contains 2 GB of data
So splitting into to tables is a little complicated. (there are a lot more fields that use in other circumstances. )
I want a chart where the only dimension is "Kilde" and then the "kilde" share of the customers revenue based on their production to the customer.
As you can see in reply under this replay. (I only want to use dimension "kilde" in chart. )
Berlingske 300.000 (Revenue, from customer 20)
BT 66.667 (2/3 revenue from customer 10)
EB (33.333+200.000) (1/3 revenue from customer 10 + revenue from customer 15)