Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ljackson
Creator
Creator

Total Mode 'greyed out' - no partial sums showing

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

.

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Try to AGGR your expression

SUM(

AGGR(

     copypasteyourexpressionhere,

     Dim1,Dim2,Dim3  // All of your dimentions

)

)

View solution in original post

22 Replies
danieloberbilli
Specialist II
Specialist II

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

kiranmanoharrode
Creator III
Creator III

Dear Leah,

Please post sample Application for better understanding

Regards

Kiran Rode

Clever_Anjos
Employee
Employee

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

kumarnatarajan
Partner - Specialist
Partner - Specialist

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.

Not applicable

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
Employee
Employee

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

ljackson
Creator
Creator
Author

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:

pivot.jpg

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

The expressions are as follows (in order):

1.

exp1.jpg

2.

exp2.jpg

3.

exp3.jpg

4.

exp4.jpg

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:

presentation tab.jpg

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
Creator
Creator
Author

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.