Total Mode 'greyed out' - no partial sums showing

[ljackson]

I am trying to show partial sums on my pivot table, I normally have no problems, so can't understand what why today I'm having difficulties!

I have selected the 'partial sum' on the relevant expressions in the presentation tab, but no total rows appear.

I noticed in the expressions tab the Totals Mode box is completely greyed out ....for all the expressions (see attached screen shot).

Can anyone point in the direction of enabling the totals?

Many thanks

.

[danieloberbilli]

Do you use a calculated dimension? This might be the reason...

[kiranmanoharrode]

Dear Leah,

Please post sample Application for better understanding

Regards

Kiran Rode

[Clever_Anjos]

Pivot table does not have this option, only straight table. This is how it is

[kumarnatarajan]

Hi Jackson,

The Pivot table "Total mode" option not allowed. So go to Presentation Tab -> There you will find "Subtotals". subtotal we can manage there.

[#6]

hey Jackson,

     in pivot table you will never see that "Total Mode box" enabled . it is always disabled.

try taking new pivot table with sample expression and you will always find as disabled.

[Clever_Anjos]

Partial sums into pivot table are configured at "Presentation" tab

[ljackson]

As I stated in the initial query, I have already selected the 'partial sum' indicators in the presentation tab.  I just wondered if the totals mode being greyed out contributed to the lack of totals showing on the chart. I guess not.

My next step is to rule out an 'odd' expression.

This is my pivot table:

I want to show totals (partial sums) under each 'Prod Grp No'.

The expressions are as follows (in order):

1.

2.

3.

4.

As you can tell from the expressions, I only want to show products with a margin over 40%, any under 40% are replaced with null.

This is my presentation tab settings:

I can't upload the file as I don't have authority to share this company data on a public forum.

Can anyone see any glaring reason why the partial sums aren't showing?  Am I asking too much from the pivot table?

Thanks again for your time and help.

Leah

.

[ljackson]

No, none of the dimensions are calculated, I've just added more info.

Thanks for your time.

[Colin-Albert]

Tick the Partial Sums option on each dimension you want to be summed.

Ticking partial sums on Prod Grp No will just add an overall total.

Tick the partial sums option for ProductDesc as well.