topic Re: MONTHLY TREND CALCULATION in App Development

MONTHLY TREND CALCULATION

panipat1990 — Thu, 02 Mar 2017 05:20:25 GMT

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

Re: MONTHLY TREND CALCULATION

panipat1990 — Thu, 02 Mar 2017 06:09:38 GMT

Still be Waiting

Re: MONTHLY TREND CALCULATION

mdmukramali — Thu, 02 Mar 2017 09:32:42 GMT

Hi Gourav,

Data:

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

MonthName(Date) as MonthYear,

Sale,

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;

Re: MONTHLY TREND CALCULATION

panipat1990 — Thu, 02 Mar 2017 10:10:20 GMT

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