Open Document Hyperlink

Hi,

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.