Amount Brackets

[mario-sarkis]

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

[MK_QSL]

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

[mario-sarkis]

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 ?

[mario-sarkis]

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

[MK_QSL]

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 🙂