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