MONTHLY TREND CALCULATION

[panipat1990]

Dear Team,

I stuck a requirement.I have a data from Last Two years. And i want to make monthly trend report in straight table One to one expression. For this i make a result format below.

ID	CM	CM-1	CM-2	CM-3	CM-4	CM-5	CM-6	CM-7	CM-8	CM-9	CM-10	CM-11	CM-12	CM-13	CM-14

Each Month's Column Data Should be On Max Date..Suppose in one Month 4 Dates exists Like In Feb Month 22 Feb,23 Feb,24 Feb.

In CM-1's Column data only 24 feb means each month's maximum date..same like previous month..

For this i am sharing data ..In Each Column  data exists only maximum date. And Second Sheet Result As required

[panipat1990]

Still be Waiting

[mdmukramali]

Hi Gourav,

Data:

LOAD Date(Date,'DD/MM/YYYY') as Date,

MonthName(Date) as MonthYear,

     Sale,

     ID

FROM

(ooxml, embedded labels, table is Data);

Join(Data)

LOAD MonthYear,

  Max(Date) as Date,  1 as Flag

Resident Data

Group By MonthYear;

NoConcatenate

LOAD *

Resident Data

Where Flag=1;

DROP Table Data;

[panipat1990]

i want to create in Only in straight table Using 15 expression.