CONVERT TO TEXT BOX

[shravanveer]

HI,

Given Table Convert to  TEXT BOX Like   " 1=8.46%"

[MayilVahanan]

Hi

Try like below

=Concat(Distinct Aggr(Category&'='&Sum(LineSalesAmount), Category), chr(13))

for sorting:

Concat(Distinct Aggr(Category&'='&Sum(LineSalesAmount), Category), chr(13), Aggr(Sum(LineSalesAmount), [Category]))

[shravanveer]

 thank you @MayilVahanan 

but how to get the value in percentage ?

[MayilVahanan]

Hi

Instead of using, "Sum(LineSalesAmount)", u can use ur percentage expression.

like num(urexpression, '#,##0.##%')