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: 
LP27
Creator II
Creator II

How to not display Total for single row in pivot table in QS

Hi Everyone,

I have got the below scenario-

Where the total should not display for specific row(internal, Internal is a measure used ) in pivot table. 

Like the below,

Name TotalOct-2019Sep-2019Aug-2019Jul-2019
SamExternal102224
 Others51031
 Internal105023
JohnExternal42020
 Others51112
 Internal22000

 

Desired Output-

Name TotalOct-2019Sep-2019Aug-2019Jul-2019
SamExternal102224
 Others51031
 Internal 5023
JohnExternal42020
 Others51112
 Internal 2000

 

Note: - For Total I  am selecting a slider button in Months Column.

Please let me know if this is possible in QS.

 

Thanks in advance

Labels (2)
1 Solution
3 Replies
berkarmagan
Partner - Creator
Partner - Creator

Hi,

I think you should review Dimensionality () and secondarydimensionality(), i think they'll work.

 

LP27
Creator II
Creator II
Author

Yes I have heard that Dimensionality () and secondarydimensionality() can solve problem but not sure who to use that logic in my case.