4 Replies Latest reply: Oct 27, 2014 12:40 PM by Manish Kachhia

# Amount Brackets

hi all,

please can anyone tell me how to write this following bracket by this order into a script

 [>=1M] [750K - 1M] [500K - 750K] [250K - 500K] [<=250K]

Thank You

• ###### Re: Amount Brackets

provide some more information... If you have created these in script,,, you can use dual function to generate sort order.

• ###### Re: Amount Brackets

i didnt Create it i just need to creat it in a script is it ana inline table or something if it is how should i write it ?

• ###### Re: Amount Brackets

I want This OUTPUT to show

% : means a cumulatative pourcentage

 Cash In USD Bracket No Clts % Cum. [>=1M] 390 7% [750K - 1M] 126 10% [500K - 750K] 273 15% [250K - 500K] 723 28% [<=250K] 3,795 100% TOTAL 5,307
• ###### Re: Amount Brackets

Load *, RowNo() as SortingOrder Inline

[

Cash In USD Bracket, No Clts

">=1M", 390

"750K - 1M", 126

"500K - 750K", 273

"250K - 500K", 723

"<=250K", 3795

];

Create a Pivot or Straight Table

Dimension

[Cash In USD Bracket]

Expression

1)

SUM([No Clts])

2)

RangeSum(Above(Sum([No Clts]),0,RowNo()))/SUM(TOTAL [No Clts])

Don't forget to change the 2nd expression to % Format using Number tab :-)