asked on November 10, 2017
Is it possible to calculate total Net value instead of Grand Total??
Total Net = Total Cash In - Total Cash Out
⋅ 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
⋅ November 10, 2017
Thank you!
⋅ November 10, 2017
Thank you!
