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