calculated dimesnion

[manoranjan_d]

Hi all,

I want to do calculated dimension(line chart) for the month field where it should get the latest year of the months only..

can you one help for this

example

year	month	dept	AMT
2016	JAN	CSE	100
2016	FEB	IT	200
2016	MAR	EEE	300
2016	APR	CSE	400
2015	JAN	CSE	500
2015	FEB	IT	600
2015	MAR	EEE	700
2015	APR	CSE	800
2015	MAY	EEE	900
2015	JUNE	CSE	1000

[sunny_talwar · Accepted solution]

May be this as the calculated dimension:

=If(year = Year(Today()), year_month)

[manoranjan_d]

how to sort these?

[manoranjan_d]

sorting on month wise

[trdandamudi]

In Sort tab, Numeric Value ascending. See screen shot: