Is it possible to calculate NET value?

Is it possible to calculate total Net value instead of Grand Total??
Total Net = Total Cash In – Total Cash Out

Attachments:
CashInCashOut.png

3 answers

Public
Tanya Gryshko Flexmonster November 10, 2017

Hello, Javier,
Thank you for your interest in Flexmonster Pivot.
You can achieve such kind of functionality the following way:
1. Preprocess original data and add two new columns, CashIn and CashOut.
2. Create calculated value NET based on the difference between CashIn and CashOut.
The total value of NET will show Total Cash In – Total Cash out.
Please have a look at the example demonstrating this approach: https://jsfiddle.net/flexmonster/2h5hmmyj/.
We would be grateful for your feedback.
Regards,
Tanya

Public
Javier November 10, 2017

Thank you! 

Public
Javier November 10, 2017

Thank you! 

Please login or Register to Submit Answer