Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use this for 2nd pivot table
Dimension
YEAR
expression
SUM(Aggr(IF(SUM(Premium)-SUM(CLAIM)<0,1,0),POLICY_NO,NAME,YEAR))
Use this for 2nd pivot table
Dimension
YEAR
expression
SUM(Aggr(IF(SUM(Premium)-SUM(CLAIM)<0,1,0),POLICY_NO,NAME,YEAR))
Hi ,
you could just tweek your expression a little
=sum(IF((Premium-CLAIM)<0,1,0))