Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

claudialet
New Contributor III

Show only certain rows in auto Total column generated by QS pivot table?

 Since TOTAL columns in QS pivot tables are automatically  created by Column > Total  option. 

Is it  possible to display only certain rows in auto generated Total column ?   Only sHow auto Totals for 2 rows ?

 

Capture.JPG

 

 

 

 

3 Replies
Partner
Partner

Re: Show only certain rows in auto Total column generated by QS pivot table?

Explain a little more, what is the purpose and condition for it?
claudialet
New Contributor III

Re: Show only certain rows in auto Total column generated by QS pivot table?

expression : sum ( amounts)
column: company
Dimension : Description
Partner
Partner

Re: Show only certain rows in auto Total column generated by QS pivot table?

I mean the goal of you wanting to do that. Because maybe there is another way to do what you need.