calculating dimension based on previous date in straight table
Hi, I need help in straight table chart where i need to show previous month dimension value along with current month. Chart is consists of Date, Customer, Status & sales. If my current month is Jan-15 then i want to display the status of that customer for Previous Month and the Previous Quarter in the same chart. For previous quarter, last month of that quarter is considered not all 3 months. How can i have this data in my chart. I have attached a sample qvw file & expected output in xls file. Thank you for your help.
