I have an issue with a calculation in SSRS 2016. My tablix reports on orders and has 3 row groups. From outside to inside that is:
- Whether the order was closed or missed (boolean)
- Market segment
- Market subsegment
I also have a column groups for month and year-to-date.
My problem is that I want to perform a calculation for the ytd column group that involve results from both the "closed" and "missed" results in the row groups, for the market group and subgroup records. I've tried to illustrate it in attached example.
Anyone have any idea what expression i can use to achieve this? Not sure if it matters, but the datasource is an SSAS MDX cube.