Filter 2 tables by different months for M/M comparison
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.
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
