my pivot table has 2 dimensions (A & B in screen capture hereafter).
"Délai route moyen" is a calculated expression with a syntax like : sum( integers) / count(distinct dimensions).
I would like to be able to fit next column ("Délai route moyen appel1") with the value of "Délai route moyen" located on the line where A=B.
In the example hereafter, value should be 6.
Line where A=B may not be the first one.
Formula I tried is something like :
max( total A aggr(if(A=B, formula of "Délai route moyen",0) ,A)
Infact what is the matter is that I need first to calculate the formula of "Délai route moyen" (which is containing agregate functions) and then keep only the right line...
I would like to have this value repeated on each line. It would be used to calculate on each line in a third column the difference between "Delai moyen route" and "New column".
it should look like screencapture (modified with photoshop... ) hereafter and completed by another column which would calculate the difference between "Délai moyen route" and "New Column"
Thanks for your help