Adding values of different period

[#1]

Hello,

Find attached xlsx file, I have actual field, Month field, and Year field.

How do i add SP1, SP2, SP3, SP4, MI1, MI2 to Dec value so i have only

12 months of the year.

i.e the to total value of SP1...SP4 + MI1 +MI2 +Dec = Dec.

How do i resolve this?

Regards

Emac

[anbu1984]

Load Year,Month,Sum([Actual Price]) As [Actual Price] Group by Year,Month;

Load Year,If(Index('SP1,SP2,SP3,SP4,MI1,MI2',Month),'Dec',Month) As Month, [Actual Price];

LOAD Month,

     [Actual Price],

     Year

FROM

(ooxml, embedded labels, table is Sheet1);