Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mrbqlik2009
Contributor III
Contributor III
‎2019-09-16 09:05 AM

show sum of Expression column in Pivot Table

Dear,

I have pivot table like photo attached.

I put CusstomerName, Bus. Area and Vouch in Dimension and put another in Expression.

I want calculate and show sum of EUR bellow that.

Labels (1)
Labels
Preview file
44 KB
1,055 Views
0 Likes
4 Replies
maxronny
Contributor III
Contributor III
‎2019-09-16 09:51 AM

go to the pivot properties, graphics, clic on "show partial sum"

1,037 Views
0 Likes
sergio0592
Specialist III
Specialist III
‎2019-09-16 09:52 AM

Hi,

Try with "Show as partial sum" in presentation tab.

 

 

 

 

1,035 Views
0 Likes
mrbqlik2009
Contributor III
Contributor III
‎2019-09-16 01:22 PM
Author

In response to maxronny

show partial sum is disable for Expression column.

1,004 Views
0 Likes
maxronny
Contributor III
Contributor III
‎2019-09-17 04:22 AM

In response to mrbqlik2009

send me a file qvw with example data

988 Views
0 Likes