Pivot table js subtract two column values

[mamtakathar]

Hello @nicolaskruchten

I have this pivot table I created using your library pivottable.js, with the rows and columns as shown in the image below.

I wanna be able to subtract the sum of sales in the current Quarter( say 2018 second quarter) from the previous quarter ( say 2018 first quarter) and also convert into a percentage value, in a separate column.

Is that possible?

Thank You,

Mamta

[nicolaskruchten]

No, this is not possible... all cells in the pivot table output are computed the same way, you cannot have certain columns that are computed differently.

…

On Wed, Apr 18, 2018 at 17:12 mamtakathar ***@***.***> wrote: Hello @nicolaskruchten <https://github.com/nicolaskruchten> I have this pivot table I created using your library pivottable.js, with the rows and columns as shown in the image below. [image: image] <https://user-images.githubusercontent.com/20275611/38958188-243cf5e6-4322-11e8-883f-3369a243b2c2.png> I wanna be able to subtract the sum of sales in the current Quarter( say 2018 second quarter) from the previous quarter ( say 2018 first quarter) and also convert into a percentage value, in a separate column. Is that possible? Thank You, Mamta — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#910>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAMbA4EVo8oqftkLbaYJBY9Hf1L5bAg2ks5tp6w4gaJpZM4TayEx> .

[mamtakathar]

Got it. Thank you @nicolaskruchten.