Hi,
I have two problem with the pivot table and set analysis.
First: I would like to calculate the percentage difference of a value based on the previuos year. I use the above, but when I select only one year the expression doesn't work. Any idea?
Second: I need to calculate the index on the basis of one year (2000) and with the Set Analysis works, the problem is that when I choose different years since 2000, however, showed me the value 2000 in dimension. Any idea?
I attache the example.
Thanks