Count of Portfolio names on grouping of PM and Type of Fund in Qlikview Chart

[ramsurya]

Hi Team,

I need to calculate below expected column on basis of Grouping of PM, Type of Fund and count of portfolio Name.

PM	Type Of Fund	Portfolio Name	Expected Output
Kumble	Sec	ABC	2
Kumble	Sec	PQR	2
Kumble	Others	DWS	1
Thomas	Sec	ABC	1

[sunny_talwar · Accepted solution]

Try this

Count(TOTAL <PM, [Type Of Fund]> DISTINCT [Portfolio Name])