Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi and thank you in advance..
I have a Pivot table which is calculated from the load script with a cumulative last day of the month value Flag - I want to calculate % +or-.
EG...
Regions Sales 1 Sales 2 % +/-
Region 1 100 90 ?
Region 2 200 210 ?
Region 3 150 131 ?
Should this be done in the load script (If so how)?
Or
Better as an expression calculation!
I have explored Column (1) / Column (2) - with no result.
sorry, what is ur expected result?
if Sale2 and Sale1 are your fields,
then try this
(Sale2 - Sale1)/Sale1
or try this
(sum(Sale2) - sum(Sale1))/sum(Sale1)
*******************************************
and in number tab check the percent option
make sure your sale 1 and sale 2 is enclosed with sum() function like this
sum(Sale1)
and same for
sum(Sale2)
so for third expression column(2)/Column(1) which you want and for this in number tab for this column fixed to 2 and check on show in %
hope it helps if you want variance % then try this
(column(2)-column(1))/Column(1)
Num((sum(Sale2) - sum(Sale1))/sum(Sale1),'#,##0% ')
or
(sum(Sale2) - sum(Sale1))/sum(Sale1)
& in number tab check the percent option