Pivot table (% different from previous pivot table (negative % when supposed to be positive)

[Hirosaki88]

Hi I'm having this issue whereby I'm trying to calculate the growth % between days in terms of revenue. But when I choose the option of pivot table (% different from previous day) I notice the formula is =(A2-A1) /A1. My issue is that when the A1 figure is positive the % growth shows is correct. But when the A1 figure is negative. The % shown is wrong.

For example A2 = $12096, A1= - 623. So based on the % different pivot formula it's =(12096--623)/-623 which shows a -2041% a 2041% decline. When it should be a 2041% increase.

My calculate item is greyed out and I'm not sure why.

Any help on how to show it correctly

 

[Hirosaki88]

Just to give a sample data


[TABLE="width: 806"]
<colgroup><col><col><col span="3"><col><col><col></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[TD]Sum of Transaction[/TD]
[TD]Sum of Bet[/TD]
[TD]Sum of Win[/TD]
[TD]Sum of Margin[/TD]
[TD]4.5% of Margin[/TD]
[TD]Overall Margin %[/TD]
[TD]% Grw/Decl[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD] 1,052,052[/TD]
[TD] $ 1,242,389.91[/TD]
[TD] $ 1,178,059.05[/TD]
[TD="align: right"]$64,327.43[/TD]
[TD] $ 2,894.73[/TD]
[TD="align: right"]5.18%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05-Oct[/TD]
[TD] 24,713[/TD]
[TD] $ 40,106.86[/TD]
[TD] $ 37,509.42[/TD]
[TD="align: right"]$2,597.45[/TD]
[TD] $ 116.89[/TD]
[TD="align: right"]6.48%[/TD]
[TD="align: right"]83%[/TD]
[/TR]
[TR]
[TD]06-Oct[/TD]
[TD] 28,999[/TD]
[TD] $ 58,295.11[/TD]
[TD] $ 56,686.81[/TD]
[TD="align: right"]$1,608.31[/TD]
[TD] $ 72.37[/TD]
[TD="align: right"]2.76%[/TD]
[TD="align: right"]-38%[/TD]
[/TR]
[TR]
[TD]07-Oct[/TD]
[TD] 31,795[/TD]
[TD] $ 61,148.46[/TD]
[TD] $ 63,965.45[/TD]
[TD="align: right"]-$2,816.99[/TD]
[TD] $ -126.76[/TD]
[TD="align: right"]-4.61%[/TD]
[TD="align: right"]-275%[/TD]
[/TR]
[TR]
[TD]08-Oct[/TD]
[TD] 35,013[/TD]
[TD] $ 51,892.83[/TD]
[TD] $ 50,391.27[/TD]
[TD="align: right"]$1,501.56[/TD]
[TD] $ 67.57[/TD]
[TD="align: right"]2.89%[/TD]
[TD="align: right"]-153%[/TD]
[/TR]
[TR]
[TD]09-Oct[/TD]
[TD] 134,836[/TD]
[TD] $ 113,325.05[/TD]
[TD] $ 100,732.86[/TD]
[TD="align: right"]$12,592.18[/TD]
[TD] $ 566.65[/TD]
[TD="align: right"]11.11%[/TD]
[TD="align: right"]739%[/TD]
[/TR]
[TR]
[TD]10-Oct[/TD]
[TD] 127,057[/TD]
[TD] $ 164,524.59[/TD]
[TD] $ 159,144.93[/TD]
[TD="align: right"]$5,376.22[/TD]
[TD] $ 241.93[/TD]
[TD="align: right"]3.27%[/TD]
[TD="align: right"]-57%[/TD]
[/TR]
[TR]
[TD]11-Oct[/TD]
[TD] 131,928[/TD]
[TD] $ 122,369.36[/TD]
[TD] $ 114,323.31[/TD]
[TD="align: right"]$8,046.04[/TD]
[TD] $ 362.07[/TD]
[TD="align: right"]6.58%[/TD]
[TD="align: right"]50%[/TD]
[/TR]
[TR]
[TD]12-Oct[/TD]
[TD] 106,302[/TD]
[TD] $ 89,647.23[/TD]
[TD] $ 90,270.24[/TD]
[TD="align: right"]-$623.01[/TD]
[TD] $ -28.04[/TD]
[TD="align: right"]-0.69%[/TD]
[TD="align: right"]-108%[/TD]
[/TR]
[TR]
[TD]13-Oct[/TD]
[TD] 165,891[/TD]
[TD] $ 225,901.98[/TD]
[TD] $ 213,805.42[/TD]
[TD="align: right"]$12,096.56[/TD]
[TD] $ 544.35[/TD]
[TD="align: right"]5.35%[/TD]
[TD="align: right"]-2042%[/TD]
[/TR]
[TR]
[TD]14-Oct[/TD]
[TD] 171,200[/TD]
[TD] $ 152,258.89[/TD]
[TD] $ 139,849.14[/TD]
[TD="align: right"]$12,409.75[/TD]
[TD] $ 558.44[/TD]
[TD="align: right"]8.15%[/TD]
[TD="align: right"]3%[/TD]
[/TR]
</tbody>[/TABLE]

 

[Hirosaki88]

Bump