Dear Chandoo,
Really happy to be associated with you as my first mentor to learn excel.
I have issue to create a calculated filed in pivot. Sample data is as follow:
I want a calculated filed for Balance sheet with : "closing of pervious period + PL current period - Cashflow current period"
Regards
Jay
Really happy to be associated with you as my first mentor to learn excel.
I have issue to create a calculated filed in pivot. Sample data is as follow:
Pivot reports | Details | 31-12-20 | 31-12-21 | 31-12-22 | 31-12-23 | 31-12-24 | 31-12-25 | 31-12-26 |
Balance sheet | Asset name | 100 | 140 | 140 | 140 | 240 | 360 | 500 |
PL | Asset name | 10 | 20 | 30 | (40) | 50 | 60 | 70 |
Cashflow | Asset name | (10) | (20) | 30 | (40) | (50) | (60) | (70) |
Calculated field | Closing of 2020+PL+CF |
I want a calculated filed for Balance sheet with : "closing of pervious period + PL current period - Cashflow current period"
Regards
Jay