Hi,
I have a simple crosstab with 1 measure Qty and 1 dimension Quality Responsible, which has 4 members: 3 Quality problem centres (d1 Supplier, d2 Logistics, d3 Other) coming from claim document giving negative Qty measure and a Regular sales member d4 that comes from invoice and gives positive Qty.
I use the same data in another chart object with calculated measure Claim% as sum(d1:d3,0,m1) / sum(d4,0,m1) with time dimension added in order to follow Claim% development by month.
Now my simple crosstab should work just as a slicer for the graph object, where I would hide Regular sales d4 dimension member and allow user to drill in on 3 real Quality Responsibility centers. And expecting that by choosing Supplier d1, the Claim% graph would recalculate to just sum(d1,0,m1) / sum(d4,0,m1).
But the problem is that when I drill in on Supplier, I thereby automatically deselect Regular sales, which makes the Claim% calculation give math error, as there's no Regular sales to calculate % against.
Can you think of any workaround? Calculation, visibility etc? I don't care about values in the crosstab, only for drill in slicer working as intended.
Thank you.
Lenka
Edited by user Thursday, March 14, 2019 9:49:20 AM(UTC)
| Reason: Not specified