You mean comparisons between two periods? For example Dec 2010 vs Dec 2009?
If so, you can do that with Set Analysis. I have a guide in my blog if you are new to the topic. http://iqlik.wordpress.com
Thanks for your marvellous articles:).
But I have another question, the set analysis expression is based on current max month or year. But I want to show the data in the table without user selection.
Year Month Amount Paralle Period Compare
2009 1 $30 -
2009 2 $40 -
2010 1 $60 100%
2010 2 $120 300%
Then how can I get current row's year and month to calculate the rate?