Hi,
I have developed a QVW using as of table concept and need help for calculating previous month, day and years sum(Sales).
You can see that I have made two table : AsOfTable and AsOfTableMonth
and need to know that is there any other way to combine all these table into one as I need to show 'Order Date' column as a dimension in the chart. So whenever I add AsOfOrderDate', 'AsOfMonth' and add the following expressions it gives me wrong results:
1. sum({<FlagDate={'Current Date'}>}Sales) - for current date
2. sum({<FlagDate={'Previous Date'}>}Sales) - for previous day date
3. sum({<FlagMonth={'Current Month'}>}Sales) - for current month
4. sum({<FlagMonth={'Previous Month'}>}Sales) - for previous month
So in my chart with title: 'Sales With Order Date' gives me wrong result for current month and previous month, as because they show the same values there.
So please give me an other idea to modify my script will help to overcome this problem.Also I need to show the previous week, year and last 9 months data also in the same Straight table.
Thanks,
Sandip
