WEEKDAY/ YEAR | Y12 | Y13 |
mon | USD 7.834 | USD 2.393 |
tue | USD 19.831 | USD 4.724 |
wed | USD 14.120 | USD 17.222 |
thu | USD 4.026 | USD 19.265 |
fri | USD 8.423 | USD 7.196 |
sat | USD 9.694 | USD 17.589 |
sun | USD 19.608 | USD 12.448 |
AVG | USD 11.934 | USD 11.548 |
i have the above data-set in a qlik pivot table. daily values are calculated with "sum()/count()" method; now i'd like to divide each daily value, each row, for the global yearly average (i.e. 11934 for year 2012 or first column last row). can i do that? if yes, how?!?
below my desired result (a sort of coefficient, pure numbers):
WEEKDAY/ YEAR | Y12 | Y13 |
mon | 0,66 | 0,21 |
tue | 1,66 | 0,41 |
wed | 1,18 | 1,49 |
thu | 0,34 | 1,67 |
fri | 0,71 | 0,62 |
sdt | 0,81 | 1,52 |
sun | 1,64 | 1,08 |
