In one of my fact tables I need to have a calculation/formulas that will give the data for 3 months back (Feb 7 to May 7th this yeat), QTD (from April 1st to now) or CY (Jan 1st to now). So for instance I want to have cost for 3 months from Feb 7 to May 7th of this year and my fact table is "Fact - Sales Cost"."Cost".
How do I insert the formula to so that it just gives me those particular data without going back to the rpd. I am sure there is way to use the functions. Please help