Data how to achieve a year-on-year show

[#1]

date	sale	brand	type
2012-01-01	10	Pepsi	2L
2012-01-02	20	Coca-Cola	1L
2012-01-03	30	Pepsi	1L
2011-01-04	40	Coca-Cola	2L
2011-01-12	50	Coca-Cola	1L
2011-01-13	60	Pepsi	1L

How do I get a Coca-Cola brand a year-on-year?     and the same 'type' ???

thanks.

[#2]

HI,

try with Group By Year and Brand in the load script.

[#3]

but there are more different grouping field.

[#4]

Hi,

Create a extra field as year(date) as year and use the required grouping in setanalysis

thanks,

Sampath

[#5]

Hi, Please find the attached applications and Hope this will help you