Is it possible to calculate total Net value instead of Grand Total??
Total Net = Total Cash In – Total Cash Out
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,
2. Create calculated value
NET based on the difference between
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.