Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
New QV user, I need to add a % in a pivot table based upon the same dimension "A" with a specific value.
Below a .qvw for ex. My need is to have "actu 1 / actu 2" using Nb as ind.
What is the formula ?
![]() ![]() |
| |||||||||||||||||||||||||||||||||||||
Thx for coop | ![]() | |||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||
Something like this.
More or less. But in the formula, one condition is based on the B dimension (value X and Y) and the result is wrong for "Y" value :
actu 1/ actu 2 = -86,57 % for Actu 2, Y in the pivot table you send me back and this result should be in Actua 1, Y (=> 4/30-1).
Hope you can help me .
Philippe
.