I have a QTD graph built using RSUM function on a measure for year and previous year .
Plotting a X- Y axis plot with both the measures on Y-axis vs calendar days - ( Oct - Nov - Dec ) on X-axis.
Requirement is with out adding any filters to the report can we just display data from Nov -1 to Nov 30 on the Plot. Zoom into the Graph for just the present month data. The reason for doing this is I am using a RSUM function on the column and if I add a filter for present month the QTD values change and will no longer be valid.
Any suggestions appreciated.