Solved: how to show total for specific column in report

pokarman · ‎02-07-2020

Hi All,

below snip i want to show total only for last column

other columns are calculated measure.

Mariusz · ‎02-07-2020

You can adjust the Measures that you don't want the totals on to something like below.

Measure = 
IF( 
    ISINSCOPE( Table[Plant Code] ),
    [Your Measure]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

View solution in original post

Mariusz · ‎02-07-2020

Hi @pokarman

You can adjust the Measures that you don't want the totals on to something like below.

Measure = 
IF( 
    ISINSCOPE( Table[Plant Code] ),
    [Your Measure]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn