Question about set analysis

[#1]

Hi,

I confused about set anlysis function. It's powerful.However If I want to write a expression include dimentions, the result is confusing.

Here is a example,

Year	YearMonth	sales
2006	200601	100
2006	200602	200
2006	200603	100
2006	200604	200
2007	200701	1000
2007	200702	2000
2008	200801	10000
2008	200802	20000

I want to get build a chart with Year as dimention and return first month and last month sales every year?

How to do it?

I had wrote a qvw in attachment, Pls help me to get it out.

[Miguel_Angel_Baeyens]

Hello,

You should use syntax like

sum({<YearMonth = {"$(=min(YearMonth))"}>} sales)

in any case. Dollar expansion in set analysis is always

$(=Function())

as the example above. Hope this helps.

[#3]

Thanks, you are right.

I just to try to use relative to the "year" dimention. It seems it only return one correct result.

How to deal this ?