I love the flexibility of KoolPivotTable, however I really need to add a variance $ and % from prior year and current year Does anyone have an suggestions on how to execute this? Does KoolPHPsuite have the capabilities to perform these on the fly? Any help is appreciated! Thanks

No one answered the topic?

Hi Carlos,
We have answered this question in a ticket support to Hallie. The answer depends on the nature of her data structure and query so if you have a similar problem, please let us know more detail for us to help you. Thanks!

Basically, you just need to build SQL query that get the variance that you want. The Pivot table will summarize the variance. For example, if you have 2 column Revenue and Expense and you want to get the profit, you will do:

SELECT revenue,expense, (revenue-expense) AS profit FROM table