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

#### Hirosaki88

##### New Member
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

##### New Member
Just to give a sample data

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

<colgroup><col><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>

Bump