What i get is a percentage markup for the invoice date. since the percentage are changing. Then the interval match can tell me the correct markup percentage for that invoice date. This is working if i'm showing all the lines for each invoice date.
But if i need to sum across several different markups. It goes sideways 😞
So i would love to be able to put in the match value as a static value to the table.
What i need in the end are to take the cost and remove the markup. So let's say the cost is 10. and i know for that invoicedate the markup was 20%. Then i would like to do it in the residential load
[Cost] as [Group Cost],
[Cost] / [markup percentage] as [Local Cost]
But i can't find a way to do this.
My problem are today if i do it like above and i said =SUM( Sales - ( [Cost] / Markup percentage]) ) I don't get the Gross profit. i get some kind of average which aren't correct. i have tried illustrating below.
But qlikview seems to be doing it this way?
Qlikview total now
I have created a sample of the application. but i can't remove the all the sensitive parts. so i can send it seperatly if it's needed.