I currently have a linearity chart that has the sums of three Fiscal Quarters. I also have the field [Day # in FQ], and so for the current quarter (2012 Q2), we are only up to day 46 for example. I need to create a chart that shows the total sums of [TOTAL REVENUE ($)] for all three quarters that the linearity chart is summing, but only up to the most current day in the most current fiscal quarter. So all three sums would be through day 46 in my example. Please let me know if you would have any idea how to go about accomplishing this, and if I can give you any more helpful information, and thank you so much for all your help.
Sorry I cannot upload any examples of my data because it contains confidential information regarding a publicly traded company.
The 2 says that your fiscal calendar starts with February:
,if(daynumberofquarter(Date,2)<=daynumberofquarter(today(),2),'Y','N') as QTDFlag
That goes in the load script where you load your calendar, where you load your Date field into the calendar table. This is one more field you are loading, just like the other fields in your calendar.
