Calculation expression in a Text Object

[sk88024]

Can somebody please help me to get the expression in a text object to calculate the share of profit contributed by Shirt category in %.

category	Profit
Shoe	500
Tablets	3000
Mobile	500
Shirt	1000

[Anil_Babu_Samineni · Accepted solution]

Sum(Profit)/Sum({<Category={'Shirt'}>} Profit)

[sk88024]

It worked with a little modification.

=Sum({<Category={'Shirt'}>} Profit)/Sum(Profit)*100 & '%'

Thank You!

[manoranjan_d]

=Sum({<category={'Shirt'}>} Profit)/sum( total Profit)*100&'%'