Showing two types of financial data in the same pivot table

[futureexcelpro]

Hi,

I have a pivot table which consists of financial data. Some of the data are balance sheet type values (such as capital or employees) and some of them are income statement type values (such as revenue or costs). In balance sheet type values, I would want the pivot table to show the last value (I don't want to sum for example the number of employees or the value of buildings from this and last month). In income statement type values I want it to sum all values (for example revenues from last and this month). How would it be possible to do this in pivot or is the only option to do it in two separate pivot tables?

In case this in unclear, I tried to visualize this in the table below. In employees I would want the total to be the value of last month (16, and not sum together 15+14+16) and in revenue I want 600 (I want to sum 100+200+300).

Thank you in advance for any help.

	Month 1	Month 2	Month 3	All year total
Employees	15	14	16	16
Revenue	100	200	300	600