0
Hello,
    I am hoping to get some help on a view which needs to be pivoted, I am not sure though.
    View is in following format:

Case       CASE_ORDER     MANAGER    CURRENT_MONTH_CASES      FISCAL_YEAR_CASES
-------------------------------------------------------------------------------
case_1          1           John            15                     84        
case_1          1           Jeff            10                     80
case_2          2           John            20                     90
case_2          2           Jeff            13                     65
case_3          3           John            7                      72
case_3          3           Jeff            17                     70

My final chart should look like the following:

case  case_order  John_current_month  John_FY   Jeff_current_month  Jeff_FY
------------------------------------------------------------------------------
case_1     1            15                84            10            80
case_2     2            20                90            13            65
case_3     3             7                72            17            70

My problem is that managers can change and so does the number of managers from month to month, 
so I can't hard code their names (ie. 'John' and 'Jeff') and use DECODE. It has to be dynamic... 
Will really appreciate some help. Thanks in advance. 
3
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by HolidaySoft.it
0

Please post the code that you are working on, to understand the exact requirement and come up with some solutions.

0

Hello, dynamically you can not do. In fact, for the months that have 12, you can always do it with decode

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.