Is it possible to get the total by all

[suvechha_b]

How to get the Total (Back Order) as sum(backorder_qty) for all products . when a particular product is selected as show in the picture .

The chart should look like this but the total should be sum(backorder_qty) for all products not just the sum of the two rows after selection.

sample model attached.

[sunny_talwar]

I think you forgot to enable the Total Mode on expression tab?

[suvechha_b]

No , the total is sum of 31350 + 26400 .

But my req. is it should have sum(backorder) irespective of selected Product in the filter.

[sunny_talwar · Accepted solution]

Disregard my previous response, I think you might want to try this:

If(Dimensionality() = 0, Sum({1}backorder_qty), Sum([backorder_qty]))