Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total values missing in Pivot

Hello Community,

may one of you can help me.

I have a pivot table and use "show Partial Sums".

I get the Partial Sums for all values in the dimension,but for one it is missing.

Do you have an idea?

examle.png

sample.png

Regards,

Lukas

2 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Do you have a dimension or expression without a label?  If so make sure you select the "blank" row in the Dimensions and Expressions setting in your PIVOT TABLE PROPERTIES AND select Show Partial Sums for everything.

Hope this helps,

Jason

v_iyyappan
Specialist
Specialist

Hi,

Please attach a sample file if u change straight table u will get answer.

Chart - > Propertities ->Total Mode -> Sum and Presentattion its may helpful.

Regards,

Iyyappan