How can I modify

Kinetic_analytics

Hello:

How can I show the Industry only once in the column? Appreciate your help.

Thanks

How can I show every industy once only in the begining.yxmd

FYTD PLAN 2508.xlsx

Workflow

Accepted answers

All comments

flying008

There is not include FYTD PLAN 2508.xlsx for input.

Kinetic_analytics

@flying008 Just added. Thanks

flying008

What form as your want output ? maybe you need sumproduct by [Industry] ? please show a table as your want.

Industry	FYTD Plan-Nov	FYTD Plan-Dec	FYTD Plan-Jan	FYTD Plan-Feb	FYTD Plan-Mar	FYTD Plan-Apr	FYTD Plan-May	FYTD Plan-June	FYTD Plan-July	FYTD Plan-Aug	FYTD Plan-Sep	FYTD Plan-Oct
CME	30.84	61.66	92.5	123.34	154.16	185	215.84	246.66	277.5	308.34	339.16	370
Consumer & Retail	15.16	30.34	45.5	60.66	75.84	91	106.16	121.34	136.5	151.66	166.84	182
Energy	26.91	53.84	80.75	107.66	134.59	161.5	188.41	215.34	242.25	269.16	296.09	323
FIG	23.32	46.65	69.97	93.29	116.62	139.95	163.26	186.59	209.91	233.23	256.56	279.88
Healthcare	10.95	21.87	32.82	43.74	54.69	65.64	76.56	87.51	98.43	109.38	120.3	131.25
Industrials	60	120	180	240	300	360	420	480	540	600	660	720
Power & Infra	13.33	26.67	40	53.33	66.67	80	93.33	106.67	120	133.33	146.67	160
Real Estate	30.71	61.41	92.12	122.82	153.52	184.23	214.94	245.64	276.35	307.05	337.75	368.46
Technology	5.96	11.92	17.88	23.83	29.78	35.75	41.71	47.66	53.62	59.58	65.53	71.49

Kinetic_analytics

I want industry and sub-industry in two columns. All month's data is in one column.

FinnCharlton

Hi @Kinetic_analytics , is this what you're looking for?

How can I show every industy once only in the begining_FC.yxmd

Kinetic_analytics

Sorry, it is my mistake I could not make the question clear. It was my head, I thought I wrote it down. Pardon. I want only 1 industry every beginning time. I do not want filling up all industry names in the first column.

I have attached a Screenshot for your information.

Thanks

ask.JPG

FinnCharlton

@Kinetic_analytics What do you want in the date and value columns? A total? Just blank?

Kinetic_analytics

Just blank. I want to arrange my data in three columns. In 1 column, Industry, the 2nd column sub-Industry and the third column number.

FinnCharlton

@Kinetic_analytics In your starting data you have values from multiple dates, what do you want to do with the date field?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703