Displaying Pivot table results

[#1]

Hi all,

I have data in  pivot table like below and I  need to display in below hierarchy fashion only

                                                                                                   Jan               Feb      Mar      

Material Group             Category        Material                           Cost             Cost     Cost

MG1                               C1                 M1                                      100              100      100

                                     C1                 M2                                      200              300     200

                                      C2                M3                                      300              400     500

while Drill down with Material Group the result should be:    MG1       Jan| Feb| mar

                                                                                                     600, 800,800

                                                                                                                      Jan  |  Feb |  Mar

while Drill down with Material Group and Category  results    are :       MG1   C1     300   400  300       

                                                                                                                C2    300   400   500

but I have a condition while displaying  category Wise .

Example:if (category = C1 and period <201405,Sum(revenue) ,Sum(cost) )  .period is a dimension..Revenue is a key figure which is coming from different table and if the condition fails the results should aggregate as similar like above fashion..is it possible in pivot table

How should i achieve this ..

Thanks

kishore

[tyagishaila]

according to your condition if Category = C1 and period <201405

then Sum(revenue)

else Sum(cost)

are these sums you want to show under cost field?

[#3]

Hi Shaila,

yes exactly

with the same hierarchy fashion without effecting other dimension results..i.e if condition is fails ...

[tyagishaila]

Take Material Group, Category, material and Month as dimensions in pivot table,

write your condition in expression tab with label Cost.

and enable show partial sum.

I think result must be correct.