I have a daily log of entry number for 3 different stages, each stage has enter and end type.
As attached, I have enter_game & end_gameenter_match & end_matchstart_round & end_round
Now i want to find a smart way to use pivot to show 3 END value as
% difference from 3 ENTER/START value. They should be 3 percentage like below(enter_game - end_game) / enter_game
(%)(enter_match - end_match) / enter_match (%)(start_round - end_round) / start_round (%)
I just wonder if I can do it with pivot without creating new column manually.
Under value field settings, i chose 'show value as % difference from", base field is "type", base item is
"previous" and I got it right with some glitches.
Glitch one, the % is negative, it basically use
formula of (end_game - enter_game) / enter_game.
Glitch two, it show 3 unnecessary calculation in between different stages, so i get unwanted series like (enter_match -
end_game) / end_game.
I hope to find a way to fix it and get exactly what i want.
In short, what I want
to do can be done easily by manually adding a new source column for each difference and draw a new chart.
But I hope there is smarter way and pivot to do it for me.