Skip to Content
0
Dec 12, 2011 at 02:05 PM

Query issue

35 Views

Hi,

we have to implement a requirement in query.

requirement is as below:

There are 2 Key figure in Report one KF is Net Value and Second is Bonus.3 and that report has 3 Characteristics one char is Comm. No.

when user run the report(workbook) a prompt window(like variable) in that prompt window , user will give the Bonus Percentage(Ex: 1.5 %) in the Prompt window and press execute then the Bonus will be calculated as 1.5 % of Net Value for each Comm. No. and Bonus Values will e displayed in Column corresponding to Bonus KF for each Comm. No.

How can we implement this.

Regards

Atul