Aggr Over Certain Fields

[Anonymous]

Trying to Create a column (SalesOfFirstMonth) in a chart to pick Sales value of Month = 1 and show against all the clients for that Year. Need to do this on chart level and not in the script. Tried via creating a variable but it shows 105 in all rows.

Client	Month	Year	Sales	SalesOfFirstMonth
a	1	2015	105	105
b	2	2015	95	105
c	3	2015	80	105
d	4	2015	95	105
e	5	2015	100	105
f	6	2015	90	105
a	1	2014	85	85
b	2	2014	95	85
c	3	2014	79	85
d	4	2014	110	85
e	5	2014	90	85
f	6	2014	80	85

Thank you.

[sunny_talwar · Accepted solution]

This expression should do it:

=Sum({<Month = {1}>} TOTAL <Year> Sales)

Best,

Sunny

[ziadm]

use Min Function to select the 1st Month

Min(Month(Date))

[anbu1984]

What is the desired output?

[jagan]

Hi,

Try this expression, if you always have 1 as the starting month

=Sum({<Month = {1}>} TOTAL <Year> Sales)

Regards,

Jagan.