Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago
Solved

Subtotal text value as dynamic

Hi Team, Is it possible to change the subtotal labels as dynamic. Currently there is no option to change subtotal labels to dynamic based on the values. Can you all help on this.     
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi prakash11440278 ,

     

    Based on your description, you can use INSCOPE() to create a measure as follows.

    For example, I just want the subtotal of column "C2" to be displayed.

    Measure = IF(ISINSCOPE(test_subtotal[C2]),SUM('test_subtotal'[Value]))

    Result:

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi prakash11440278 ,

 

Thanks for your reply. Currently I don't think it is possible. I did a test as follows.

If you set "Rows subtotal position" as "Top", the label is Item name and it will not be changed by "Row subtotal labels".  If you set it as "Bottom", all the subtotals will be changed as the same ones.

 

 

 

 

 

 

 

 

 

 

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

prakash11440278's avatar
prakash11440278
Post Prodigy
4 years ago

Hi Anonymous , Thanks a lot for your reply.

As i know this not possible in Matrix chart. Any alternate solution i can use and acheive the same functionality please?