Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Prompt Answer to Metric

Status
Not open for further replies.

szeiss

Programmer
Apr 5, 2000
137
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top