Only show 1 column grand total

[rileybloke]

Hello,

I have my powerpivot table with the values on the rows instead of the column, but when I enable the option to show grand totals for columns it creates a grand total for each of my values. But I only want to show the grand total for one of the values...

Below is a screen shot of the table, i only want to show the grand total of the Total Over Cost values for each column...

https://onedrive.live.com/?cid=081b7eb8ab14f5c8&id=81B7EB8AB14F5C8!76403&action=Share

 

[Jacob Barnett]

Two options I can think of:

1. Package your core measure in a wrapper that establishes whether the row is a total and if so returns blank (obviously you wouldn't do this for 'Total Over Cost') e.g.

=IF(HASONEVALUE(Table[Item]), BLANK(), SUM(Demand))

This only returns the sum where there is only one item.

2. You could use a 'set'. Basically on the pivot you have created, go in 'Fields, Items & Sets' in PivotTable options and 'create set based on row items'. You can then add/remove the relevant rows

 

[rileybloke]

Brilliant, thanks