I have a straight table which currently shows month on month comparison for sales. What I want to show is the comparison between any given months not just consecutive months. Note in my case my months 1-12 are marked as period.
You can use two variables. Create an input box with two variables vPeriod1 and vPeriod2. Change your expressions to use the variables: Sum({<PERIOD={$(vPeriod1)}>} $(vCurrencyField))