creating totals in a pivot table

[#1]

Hi guys,

I have a questions regarding the totals in a pivot table. I've noticed that if I create total by selecting Show partial Sums, it will display the sums of the measures. What if I don't want to display the sums?

In the attachment you'll find a pivot table which shows up the Actual Prices, MP Prices, PY Prices Mth and PY Prices Avg for each Group Material, split for month.

Now I want to show up these indicators at total level, not including the detail for Group Material.

How can I do?

Please, see my attchament.

[jvitantonio]

Hi Cristina,

If you don't want this level of granularity, then remove Group Material and leave only the Month that you are using as columns.

Then, replace your formulas with an aggregation by group material:

sum(aggr([Act/Fact], [GroupMateria], Month))

I hope this helps.

JV

BI Experience | A place to share our Business Intelligence experiences

[Gysbert_Wassenaar]

Try creating a new field and use that in the pivot table

TableForExtraField:
LOAD * inline [
GROUP_FOR_PIVOT, GROUP MATERIAL
Natural Rubber, Natural Rubber
Synthetic Rubber, Synthetic Rubber
Carbon Black, Carbon Black
Chemicals, Chemicals
Textile reinforc., Textile reinforc.
Metallic reinforc., Metallic reinforc.
Total, Natural Rubber
Total, Synthetic Rubber
Total, Carbon Black
Total, Chemicals
Total, Textile reinforc.
Total, Metallic reinforc.
];

If you then use GROUP_FOR_PIVOT instead of GROUP MATERIAL you'll get the Totals at the end like you want.