Pivot: Aggregate Certainty Field Not All Fields

[muhammad susanto]

hi all

how to make formula or tricks in pivot table that in col "Target of Year" the value do not aggregate summing based on date but the other field keep aggregate summing
aggregate not full for all fields.
here this layout

Book1
	H	I	J	K
3	Sum of Units
4	Date	Product	Target of Year	Running Total In
5	Jan	Coats	300	241
6		Hats	650	382
7		Shoes	700	879
8	Feb	Coats	300	928
9		Hats	650	561
10		Shoes	700	1385
11	Mar	Coats	300	1270
12		Hats	650	1493
13		Shoes	700	1567
14	Okt	Coats	300	2638
15		Hats	650	2186
16		Shoes	700	1700
Sheet2

any one help, would be appreciated greatly

.sst

 

[GraH]

Maybe by using MIN, not SUM in the pivot?

 

[muhammad susanto]

Hi
Thanks you so much...a long time I'm waiting this solution..Great!!!!

 

[GraH]

Most welcome. It was an easy suggestion to make for me. Thanks for your feedback, like and mark.