Hi,
I'm using Dimensional modelling to create my reports.
I've created a simple bar charts. X-axis= Month & Y-axis = Revenue. My requirement is I need to capture the prevous month revenue in the current month (to perfomr caluculation).
Ex: Jan 10,000
Feb 5,000
Mar 2,500
Need to get a chart as Mar = 5,000; Feb = 10,000; Jan=0;
Is it possbile in Report Studio?