Forum Discussion
Nested Drillthrough giving Summarized values at second drill report
Hi,
I have created 3 reports Branch wise Sales Qty and Amount, Customer Group Wise Sales Qty and Amount and then , customer wise Sales Qty and Amount
I am drilling down from Branch level to Customer Group and then to Customer report.
at the customer level report when i drill against a particular group qty and Amount is same for all customer which is the summarized value of that Customer group.
Customer GroupCustomer Wise del_Qty & Del_Amt is same.
3 Replies
- sanjaysinghHelper I
Hi,
Please find the Pbix file placed in one drive.
Below is the link.
- v-chuncz-msftCommunity Support
You may set cross filter direction between 'Budget_data' and 'BP_Master' to 'Both' in the Edit relationship dialog.
- sanjaysinghHelper I
After doing That , now bud_Qty and Bud_Amt started facing problem,
now rest of the column except del_Qty and Del_Amt are showing same values.
All the coulmns which are coming from Budget data table are showing same values.
I am attaching the revised pbix file on one drive below is the link.