A table lists multiple events where each event has four attributes (columns), call them A, B, C, P
It would be simpleto pivot to get a table with columns for A, B, C, P=1, P=2, P=3, etc.
However, I need the columns to be A, B, C, P<1, P<2, P<3, etc.
In other words, if a row of the "simple" way were X, Y, Z, 7, 3, 5, 2 then what I actually need is X, Y, Z, 7, 10, 15, 17 because any P less than N is also less than N+1.
I know I can compute the values (X, Y, Z, 7, 10, 15, 17), load them into a temporary table, and pivot that, but maybe there's something simple that my SQL talents don't recognize immediately?
If it matters, the result will end up in SSRS.