Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table which I have already created and lots of set analysis are done into it:
Loan Index
A 55
B 30
C 56
D 50
E 80
How can I actually split the above table into a nicely pivot table:
Index Percentage band Number of entries
0-30 1
31-60 3
61-100 1
Would need to code the percentage band and check the index to ensure they are within the band.
felix.gan wrote:The script does not solve the issue that I have got. I still get the numbers accumulated.
The example I gave doesn't accumulate, so your problem lies elsewhere. As Trent said, perhaps you have accumulation turned on. Properties -> Expressions -> Accumulation. It should be "No Accumulation". You could also be accumulating with the expression, like if you're doing some sort of rangesum() with above(). Don't do that. Or maybe you have a data model that forces accumulation, which is a trick I sometimes employ in examples. Don't do that either. But basicaly, you actually have to do something in order to get accumulation. Accumulation isn't the default. So you did something you shouldn't have done.