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

[Gysbert_Wassenaar]

Enable the option Partial Sums for the dimensions and expand/collapse dimension values as needed.

[#3]

Hi gwassenaar,

Can you please elaborate your solution and where should i find Expand/Collapse my dimension results in Pivot table

thanks for your Quick Response

[#4]

gwassenaar

I need to show the Results for category  wise based on the condition written in above.if condition fails results are displaying as similar like above exaple..

i was applying Partial sums options i am failed to get my expected results.

[Gysbert_Wassenaar]

The default setting for a pivot table is to show + and - icons that you can click on the expand that dimension value to show the details of the next dimension. You can enable/disable this by changing the Always Fully Expanded setting on the Presentation tab of the charts properties window.

[#6]

Hi

I am displaying in the same fashion but my requirement to view the results on Category based on the Below Condition

Can you help me where should i apply this condition...Category is A dimension

Example:if (category = C1,C2.... and period <201405,Sum(revenue) ,Sum(cost) )

period is a dimension..Revenueis 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

Thnks

[Gysbert_Wassenaar]

Please post a .qvw document that demonstrates the problem.

[#8]

Hi,

unable to share my .qvw document i have no permissions to share .

I am giving the example based on my Actual requirement.

[tyagishaila]

Presently where are you using this condition?

if (category = C1 and period <201405,Sum(revenue) ,Sum(cost) )

use this condition in expression and allow Show Partial Sum in Presentation Tab for MaterialGroup.

[#10]

Hi ,

Currently I am  not using this condition anywhere ..i am  displaying the results whatever the data available in my dataset

and Displaying like Collapse and Expand fashion based on Material group catgory etc..

Now i have a requirement to drill down  Category dimension based on the above condition..where should i apply without effecting hierarchy fashion i.e(collapse and expand)...Revenue is coming from different table which is joined internally but currently not populating in my Pivot table

Thanks for your quick response