Conditional Calculation in a chart

[Hamid_Reza_Rashidi]

Hi, everybody

Merry  Christmas

I have following table and going to have a Bar Chart

X-Axe be "Ord_Mah"

Y-Axe be (the sum of  Ord_Qty for the Max of Date_S.

(Please check the Pivot table at the end of this post.

Ord_Mah	Date_S	Tech_No	Ord_QTY
Azar	13990927	YGVQ	28
Azar	13990927	1101	16
Azar	13990927	1001	50
Azar	13990929	YGVQ	30
Azar	13990929	1101	20
Azar	13990929	1001	60
Azar	13990930	YGVQ	32
Azar	13990930	1101	24
Azar	13990930	1001	70
Azar	13991001	YGVQ	34
Azar	13991001	1101	30
Azar	13991001	1001	80
Azar	13991002	YGVQ	36
Azar	13991002	1101	34
Azar	13991002	1001	90
DAY	13991003	YGVQ	35
DAY	13991003	1101	60
DAY	13991004	YGVQ	38
DAY	13991004	1101	70

Date_S	Azar	DAY
13990927	94
13990929	110
13990930	126
13991001	144
13991002	160
13991003		94
13991004		108

Best wishes.

[edwin · Accepted solution]

if the requirement is to show only the ones in bold, try this expression:

= Sum(
	Aggr(
		If(Date_S = Max(TOTAL <Ord_Mah> Date_S), sum(Ord_QTY))
		, Date_S, Ord_Mah
	)
)