
Hi,
I think that's been done before but somehow not working for me.
I have a requirement where I have a stacked bar with No. of records as Labels and in the next sheet I have a Table displaying related values like customer name..
What I want is if I click on Number of records the corresponding sheet should display the number of customers as per the number clicked.Not on the Measure value or any other field.
Attaching a sample workbook.
Thanks
Hi Ankit,
Please find below Screenshot,now notice that there are more than 1 records for customer so due to this you count is not matched. when you drill down further it will gives that 2 records.
E.g. See customer penelope sewall (Shown below), which shows 2 records for furniture.
Now when I drill down category it will shows that 2 records in detail, due to this your count is different.
I hope you understood.