report

[johny.cbi]

I've cross tab report(Source), I want to add one Text BOX in source report for 'SALES AMOUNT' cross tab report(Target)

If I click on the text box it has to show the sales amount (Drill through is working fine )
In Target I have Total sales amount (Total sales for all regions eg: cle,Hou,Bos)
If I run the Target report, I can see the sales for all regions

my question

I need the total sales amount number(not regions) in the source report
If I click on sales amount number it has to show target report with regions sales

I want to add total sales amount number in the source report

please share your ideas