pivot table help

[Anonymous]

Hi,

Hope every one is fine.Please i need help for the following issues.

MM   SUPP  TYPE_OF_COST _AMT_COST

JAN  S1                R           100

JAN  S1                P           100

JAN  S1                C           100

JAN  S1                C           100

JAN  S2                R           100

JAN  S2                R           100

JAN  S2                P           100

JAN  S2                C           100

JAN  S2                C           300

out put should be like

          MM

          ==

         JAN                  

==========================

cost_type         suppS1   CUMMS1     suppS2   CUMMS2

R                      100            100               200             200

P                       100            200              100             300

C                       200            400             400             700

regards

[kaushiknsolanki]

Hi,

    You can do this with straight table.

    Have a look at the attachment.

Regards,

Kaushik Solanki