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