I want to create buckets of Top10 , top 10-20 and others and its percentage of total value

[Vinni2000]

Top 10 Contracts	55%
Top 10-20 Contracts	25%
Others	20%

[hic · Accepted solution]

Try the following:

Dimension:

=Aggr(
If(Rank(Sum(Sales))<=10,Dual('Top',1),
If(Rank(Sum(Sales))<=20,Dual('11-20',2),
Dual('Others',3))),
Contract)

Measures:

Sum(Sales)

Sum(Sales)/Sum(total Sales)