Filter 2 tables by different months for M/M comparison

[ssc8aug]

Hi,

I have a simple problem, I need to create 2 simple tables side by side. One table will show number of customers for the selected month, I need the second table to show the same values for previous month, I am selecting month from a list box, so every time I update it , the table on the right should automatically show 1 month prev values.

The month variable is not present in dimensions/expression so i need full table filetered. Please help.

[edwin]

the first table should be a simple
sum(MEASURE)

for the second table the usual solution is to use a variable to either store the selected date or previous month of selected date
vPrevious=addmonths(DATE,-1)  assuming only one date is selected
then in your expression
sum({<DATE={'$(vPrevious)'}>}MEASURE

having said that, wouldnt this be better shown as a single chart where the current month and prior months are shown side by side?  bec if the user sorts one table, the second will not follow