orginize and comabins

[boris_dol]

hello,

Im traing to get a new table from "total coast" by year and region, cant faind the right way

1/6/18	East	Jones	Pencil	95	1.99	189.05
1/23/18	Central	Kivell	Binder	50	19.99	999.50
2/9/18	Central	Jardine	Pencil	36	4.99	179.64
2/26/18	Central	Gill	Pen	27	19.99	539.73
3/15/18	West	Sorvino	Pencil	56	2.99	167.44

ty for your time

[Kushal_Chawda]

Can you please elaborate?

[boris_dol]

I need to present a new table , thats  shows total by year and region

[Kushal_Chawda]

which table and where you want to do it? In script or in front end?

[boris_dol]

In script plz

[Kushal_Chawda · Accepted solution]

You can do something like below

Data:

LOAD year(Date) as Year,

             Region,

            sum([Total cost]) as Cost

FROM Table

group by year(Date), Region;

[boris_dol]

tyvm