Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
provide some more information... If you have created these in script,,, you can use dual function to generate sort order.
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 ?
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 |
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 🙂