I have one table which have project id and status code.
Now, I want to create one view for crosstab. My requirement is i want to show some additional columns based on status code. If the status code is between 0 - 25 it will be show 1 in stage 1 column like that i want to show 10 stages based on status code(each project id have some more components and each components have status code).
Thanks