I'm a newbie with Microstrategy. This is something I've done with Crystal, but not sure how to accomplish this with Microstrategy. I will need this with probably every report I do.
The situation is, a user selects a department and a fiscal year prompt i.e. 2012 for the FY.
That number (2012) gets passed to the report and is used with the different metrics. For example I want all the expenses for FY2010, in crystal I would do a calculation something like FY-2, my next column I would want the metric for Budget FY2011. Several other metrics on the report would be either for FY2010, 2011 or 2012.
Expenses
FY 2010
Budget
FY2011
Hopefully, this makes sense.
Thanks,
Sherry
The situation is, a user selects a department and a fiscal year prompt i.e. 2012 for the FY.
That number (2012) gets passed to the report and is used with the different metrics. For example I want all the expenses for FY2010, in crystal I would do a calculation something like FY-2, my next column I would want the metric for Budget FY2011. Several other metrics on the report would be either for FY2010, 2011 or 2012.
Expenses
FY 2010
Budget
FY2011
Hopefully, this makes sense.
Thanks,
Sherry