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

[LP27]

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		Total	Oct-2019	Sep-2019	Aug-2019	Jul-2019
Sam	External	10	2	2	2	4
	Others	5	1	0	3	1
	Internal	10	5	0	2	3
John	External	4	2	0	2	0
	Others	5	1	1	1	2
	Internal	2	2	0	0	0

Desired Output-

Name		Total	Oct-2019	Sep-2019	Aug-2019	Jul-2019
Sam	External	10	2	2	2	4
	Others	5	1	0	3	1
	Internal		5	0	2	3
John	External	4	2	0	2	0
	Others	5	1	1	1	2
	Internal		2	0	0	0

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

[berkarmagan]

Hi,

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

[LP27]

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

[berkarmagan · Accepted solution]

Check this.

https://community.qlik.com/t5/New-to-QlikView/dimensionality-Vs-secondarydimensionality/td-p/985587