Hi Team,
I have a requirement as below...
From Parent report user should drill through to Child Report.
State 2013 2014
Alabama $2500 $2800
Alaska $4800 $5000
Arizona $3800 $2233
Arkansas $7600 $3200
California $8900 $5000
For example When user clicks on a measure ($2500) for Alabama in 2013 then
then child report should display for Alabama, 2013 detail sales as below...
Retailer Sale-Amount
ABC $400
XYZ $300
DEF $800
PQR $200
GHI $100
STU $400
JKL $300
Total $2500
So when we see the total of Sale-Amount in child report it is $2500 which we can see as amount in 2013 for Alabama in Main report
Can some body suggest best possible ways to achieve this requirement
Thanks in advance...
Hi sg1907,
You can create a child report with list and pass state and year as a parameter to this report from parent report. To calculate total you can do the summary.