Hello All,
This is my first post in the forum. I was asked a question in and interview and I'm still not able to figure out the answer. Here goes the question. A table has two fields - a year-month field (for simplicity & testing, I have used a 'date' field with value as the first date of a month in place of 'year-month'. eg: 01-2015 will be 01/01/2015 in my file) and Sales.
In the same table, I want to display beside the Sales field, the sales for next month. This has to be done as a Chart expression and not in script. My fields are [Month-Year], [Sales1]. [MOnth-Year] has a date instead of MM-YYYY as mentioned above. My set expression for getting the next month sales is:
sum(TOTAL{<[Month-Year]={"=$(=Date(AddMonths(Date(Date#([Month-Year],'DD/MM/YYYY'),'DD/MM/YYYY'),1),'DD/MM/YYYY'))"}>}Sales1)
I have used the 'TOTAL' keyword in the expression hoping it would disregard the dimension selections across the rows.
This expression does not seem to fetch the next month sales and returns 0.
Please let me know your solutions for this question.
