Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mrbqlik2009
New Contributor III

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.

4 Replies
maxronny
New Contributor III

Re: show sum of Expression column in Pivot Table

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

sergio0592
Valued Contributor II

Re: show sum of Expression column in Pivot Table

Hi,

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

 

 

 

 

mrbqlik2009
New Contributor III

Re: show sum of Expression column in Pivot Table

show partial sum is disable for Expression column.

maxronny
New Contributor III

Re: show sum of Expression column in Pivot Table

send me a file qvw with example data