Hi all,
I currently have one line item with 2 dimensions, and the numbers are percentages. I essentially want to strip out one of the dimensions in a new line item but to have all the percentages multiply by each other for the dimension that was taken out.
In simple terms, I'm looking for a 'Summary Method' that multiplies rather than a sum / formula / average etc.
Does anyone know how this can be done? I've attached an Excel which shows what I want to get to in the line item. Apologies if it's something completely obvious. 🙂
Many thanks