Subtotaling Customization

[Anonymous]

Hello!  

I have this table that make the different behind the two expressions 2012 and 2013,

lost in 2013 : if((Column(1)-Column(2))=-1,'0',(Column(1)-Column(2)))

But the total's label is wrong, becouse it doesn't read the "IF condition" (Column(1)-Column(2))=-1,'0).

How can I Customization it?

Cliente	2012	2013	Lost in 2013
Total	160	174	-14
A&D SRL	0	1	0
ACCENTURE OUTSOURCING SRL	1	0	1
ACCENTURE S.p.A.	1	1	0
ACOMON S.R.L.	1	1	0
ACTIV8 CONSULTING SRL	0	1	0
ADDRESS SOFTWARE SRL	1	0	1
ALLIANZ S.p.A.	1	1	0

[marcus_sommer · Accepted solution]

You need to make it more clear what is wrong and what will be the expected result. I assume you will need a different expression for total and/or and an aggr, maybe in this way:

if(dimensionality() > 0, YourExpression,

     sum(aggr(Expression2012, Cliente)) - sum(aggr(Expression2013, Cliente)))

- Marcus

[Anonymous]

Peferct!

Thank you very much!!