Here's my problem : I want to know the percentage between all the years for one data.
In my pivot table, I have no problem, but when I try to put it in a line chart, there are some issues.
I have two dimensions : all the activities and the year. (in this order)
Year
Activity
sum(Prices)
2011
Swimming pool
1.000
2012
Swimming pool
1.100
2013
Swimming pool
1.000
2011
Dojo
2.000
2012
Dojo
2.200
2013
Dojo
2.420
So, I want that my line chart has 2 lines, the first one for the swimming pool, for which in 2012, it shows +10%" and in 2013 -"10%" and for the dojo 2012:'+10%' and 2013 "+10%".
I tried to create the following expression : sum(Prices)/above(sum(Prices))-1, but it doesn't work.
(niv_3 = activities)
But when I switch the dimensions ( Year - activity), it gave me the right numbers, except that the dimensions are inversed.