To simplify, I’ve got 4 fields.
Brand, volume (kg), value (GBP) and year.
I’ve done value per kilo.
Then a % inflation delta of value per kilo this year vs last year.
Now I want to do a calculation that gives me % contribution to that delta value by brand. So of the overall 2% movement brand A has contributed 25% or something.
Would be really simple if it was just a value or volume delta and assume I’m missing something simple for the value per kilo but I’ve completely hit a wall.
Any help much appreciated.
sounds really boring, i wouldn’t bother
hope that helps
You lost me at having 4 fields
not wasting my time helping a tory out
I did try to understabd your question but ultimately couldn’t.
I did maths at uni so I can help.
just done some statistical analysis on this thread
you’re currently running at about 70% helpful replies
Are they equivalent products?
i.e. are the only variables the Brand, Year and Value?
I’m also a little confused by you using Kg to measure volume, and ‘hiding’ price to turn it into Value.
Volume is measured in cubic metres, mate. You measure mass in kilos. HTH,
helpful replies down to about 50% now
I’m pretty sure we can drag that down much further.
Trial and error Divide everything by everything else until you get something that looks about right
multiply it by pi as well
I think you need to establish a baseline inflation value, whether that’s across the whole economy (eg RPI or CPI), or product specific (only the items in your list).
You can then say whether the brand has led to an increase or a decrease above or below ‘par’ for the market.
Have you tried creating a filter
Serious answer, I think you just divide the amount delta of your individual brand by the total delta over the year to get the %age that brand has of the delta, this what they contributed to the delta