Master Calendar and Calculated Element List in Set Analysis
I am trying to create a set analysis to calculate the previous month's total, so it can be compared with totals in the month, and calculate other things like change from previous month, etc. But I can't seem to get my calculation right. My master calendar has a field for the age of the month, where the current month is 0 and last month is 1, so on. I am trying to get the month age to increment in the element list, but I do not have this right.
The attached file has some sample data and my calendar. this is what I have:
I am trying to show
I have made many tries and all I seem to get is the same month:
I expanded my sample data to include more dates. I am trying to present totals for the current month and the previous month, which the example you gave me work perfectly, but how do I show the total for the previous fiscal year. This is supposed to be comparisons of the different points in time.
Should I rework my calendar to make this easier?
Is this difficult because I am using the Month Name as the dimension? I admit, I thought this sounded simpler than it is.
Sorry about that. I intended for the new chart to have the Year Age =0, which means that is the current year, so that no year selection had to be made. I am attaching the revised QVW file. What I am trying to get to is several different 'point in time' totals for each month, to show the previous month, the current month, that month in the prior year, etc.
Again, if you have a suggestion for how to rework the calendar to make this easier, please do. Anything to make this easier!