I construct the report in ssrs . The data source is a cube ( OLAP ), in which there are such calculated fields as% approval, average loan amount, etc.

When designing, I tick the tick enable drilldown - for the deployment of parent and child groups. When you expand and collapse, the usual (non-calculated) fields of the cube are displayed correctly. But the calculated fields are displayed correctly only at the lower level of the hierarchy. At the upper levels, the first value of the expanded group is indicated. How to make the calculated fields displayed correctly (as in a cube, i.e. weighted average for the parent group)?

Help me please. 2 weeks I suffer :(

    1 answer 1

    If you need "as in a cube", then you should not use the totals and SSRS groupings at all, all data including the aggregates must be pulled from the cube. That RS itself did not calculate anything.

    • Try to write more detailed answers. - Nicolas Chabanovsky ♦