Forum Discussion

pokarman's avatar
pokarman
Frequent Visitor
6 years ago
Solved

how to show total for specific column in report

Hi All,

below snip i want to show total only for last column 

other columns are calculated measure.

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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



3 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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