I have a spreadsheet where I enter the data for revenue and expenditure, this separation of income and expense, I do through validation.
I rode with the PivotTable "Type" field, however, would like to add a calculated field where the "Grand Total" make the difference between expenditure and revenue.
I mounted the PivotTable in the spreadsheet attached in two forms, formatted and unformatted.
Important detail.
I do not want to use column help to convert negative value in spending, but also do not want to release the amount of the expense and negative. I want to do with calculated field in my pivot table.
I would keep the same layout of the formatted table.
Thanks
File: http://fyels.com/VVa00p
I rode with the PivotTable "Type" field, however, would like to add a calculated field where the "Grand Total" make the difference between expenditure and revenue.
I mounted the PivotTable in the spreadsheet attached in two forms, formatted and unformatted.
Important detail.
I do not want to use column help to convert negative value in spending, but also do not want to release the amount of the expense and negative. I want to do with calculated field in my pivot table.
I would keep the same layout of the formatted table.
Thanks
File: http://fyels.com/VVa00p
