Expression

[upaliwije]

Hi,

I have attached sampale QV document with two pivot tables in it. IN my 2nd Pivot table I want to show no of Polcies if there is a negative figure in Profit Figure. I want to display following table

YEAR	count
2015	2
2016	1
2017	1

but it actually shows only 2015 year. Can you pls help me

[MK_QSL · Accepted solution]

Use this for 2nd pivot table

Dimension

YEAR

expression

SUM(Aggr(IF(SUM(Premium)-SUM(CLAIM)<0,1,0),POLICY_NO,NAME,YEAR))

[Anonymous]

Hi ,

you could just tweek your expression a little

=sum(IF((Premium-CLAIM)<0,1,0))