I am trying to figure out how the “% difference” option works. I am getting % difference values but I cannot understand what it is calculating. For example:
(using notation row x column) 5×3, 5×4, 5×5 gives three values, but corresponding difference 5×7, 5×8, 5×9 clear does not give the correct difference between those columns. Am I using this correctly, and what is it measuring? If I am not, how would I achieve the desired effect.
Thank you for writing to us.
“%difference” expresses the percentage change from one item to another item.
Please have a look at the following example: http://jsfiddle.net/flexmonster/rkprvhhs/937/. For example, Company A has Sum of Revenue for January as
15395, for February as
5730 is by 62% less than
15395, which is displayed in this JSFiddle.
Please let me know if you have more questions.
Thanks Tanya, so you mean that % difference works on Rows and not columns? If so, how does it make work on columns?
Thank you for your feedback. If you need to have % difference for the columns please change the slice according to the following example: http://jsfiddle.net/flexmonster/rkprvhhs/960/. The
"Measures" part should be placed into the rows part:
Please let us know in case of any other questions.