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.

amitchandak's avatar
amitchandak
Super User
5 years ago

prakash11440278 , You have an option two change "row subtotal label". I think you can only rename "total" part of it

 

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago

HI amitchandak ,

Yes. If we add the subtotal text value it will be applicable for entire column, i dont want that. In above example i need to display as dynamic means x site total, y site total & z site total these all are dynamic.