Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI,
try with Group By Year and Brand in the load script.
but there are more different grouping field.
Hi,
Create a extra field as year(date) as year and use the required grouping in setanalysis
thanks,
Sampath
Hi, Please find the attached applications and Hope this will help you