Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Still be Waiting
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;
i want to create in Only in straight table Using 15 expression.