I have a unique request from the Customer. first, the User enters prompts values as City and State values and retrieves the Sales for those cities. The Webi report looks like this
City State Sales
Fremont CA 120,000
San Diego CA 90,000
Sales numbers should be hyperlink. When the User clicks on Sales of Fremont, then a new report should open up with all list of stores and sales for Fremont. Similarly for San Diego.
Can you please provide a solution for this for Business Objects 4.0 SP5
Your response will be appreciated. Thanks for your time.