headcount and spend by quarter, only spend by last 4 quarters and headcount by last 1 qtr

[ulooz]

Scenario is let's say we have customer in row, quarters in columns and spend / headcount in values.

Is it possible to only show one quarter headcount while showing 4 quarter spend in the same pivot table?

https://imgur.com/VM7ScsE for reference (it is not in pivot table format but gives you an idea of the current and desired outcomes)

 

[alansidman]

It will be easier to help you if you post to a site that lets you upload a file versus a picture. With a picture, it is difficult to determine the formatting and formulas in the worksheet. And to be honest, we can really manipulate data from a picture.

 

[ulooz]

It will be easier to help you if you post to a site that lets you upload a file versus a picture. With a picture, it is difficult to determine the formatting and formulas in the worksheet. And to be honest, we can really manipulate data from a picture.

my apologies, I thought since it was question of pivot charts and their functionality that the data would not be so ancillary. I'll put something together.

 

[ulooz]

http://s000.tinyupload.com/?file_id=77865353443689962574