How to Perform the quarter and sem calculation

[#1]

Hi,

i have a data for a year 2009 with jan,feb,mar........dec. two fields year and sales

how to calculate the sales for quarter and semester...

pls..help me out

thanks in advance

[#2]

Hi,

Hope attached sample application will help you............

Define Quarter and Semester According to your requirement...

Regards,

Nilupa

[renjithpl]

Hi,

Try this

Directory;

LOAD

Date,

month(Date) as Month,

Quartername(Date) as Quarter,

'Sem'& ceil(month(Date)/6) as Semester

FROM

TEst3.xlsx

(

ooxml, embedded labels, table is Sheet1)

;

Regards

Ren