Any alternative to unpivoting where data cant be unpivoted?

[abner0]

I am trying to create a column chart to show monthly order trend in a data set where the monthly transactions is pivoted already from the system extract? Any ideas how I can make one without having the columns side to side with space in between?

[selimovd]

Hey @abner0 ,

can you do an example? I don't really understand what you want to archive.

Thank you and best regards

Denis

[abner0]

Below sample data as received from our system monthly. 

Customer Number	CUSTOMER NAME	CTRY	FY YEAR	Product group	JAN CY ORDERS	FEB CY ORDERS	MAR CY ORDERS	APR CY ORDERS	MAY CY ORDERS	JUN CY ORDERS	JUL CY ORDERS	AUG CY ORDERS	SEP CY ORDERS	OCT CY ORDERS	NOV CY ORDERS	DEC CY ORDERS	JAN CY SALES	FEB CY SALES	MAR CY SALES	APR CY SALES	MAY CY SALES	JUN CY SALES	JUL CY SALES	AUG CY SALES	SEP CY SALES	OCT CY SALES	NOV CY SALES	DEC CY SALES	CURRENT MONTH ORDERS $$	CURRENT MONTH SALES $$	CY ORDER $$	CY SALES $$
M4521134W	ABD Company	NZ	2018 TOT	CE	180	377,849	158	332,507	332,496	394,425	456,354	-	-	-	-	-	827,929	889,858	951,787	518,836	549,841	580,846	611,851	-	-	-	-	-	1,571,077	1,633,006	1,694,935	1,756,864
G2054034W	DSDS Company	NZ	2018 TOT	FC	328	295,515	262	235,876	235,843	276,982	318,121	-	-	-	-	-	564,956	606,095	647,234	518,836	549,841	580,846	611,851	-	-	-	-	-	1,058,624	1,099,764	1,140,903	1,182,042
L8957534W	MRC GLOBAL	NZ	2018 TOT	AN	274	222,763	219	177,806	177,779	208,784	239,789	-	-	-	-	-	425,820	456,825	487,831	518,836	549,841	580,846	611,851	-	-	-	-	-	797,883	828,888	859,893	890,898
C3336434W	knsdf GROUP	NZ	2018 TOT	FD	3,525	183,306	3,132	162,878	162,681	192,470	222,258	-	-	-	-	-	400,989	430,777	460,566	490,354	520,142	549,931	579,719	-	-	-	-	-	758,450	788,238	818,027	847,815
M0997234W	Electronics Trading	NZ	2018 TOT	RE	90,331	180,662	77,045	154,090	147,447	156,214	164,980	-	-	-	-	-	217,576	226,342	235,108	243,874	252,640	261,406	270,172	-	-	-	-	-	322,769	331,535	340,301	349,067
66785034W	SUPPLY CENTER	NZ	2019 TOT	KZ	394	177,137	314	141,389	141,349	165,965	190,581	-	-	-	-	-	338,278	362,895	387,511	412,127	436,743	461,359	485,975	-	-	-	-	-	633,672	658,289	682,905	707,521

I have created various visualizations using the data with no issues. However when trying to create a column chart that shows the sales and orders montly trend it appears as below ( problem is there is no gap between the columns in column chart and also I cannot have one chart with both the sales and orders side by side by month so have to take up space by doing two charts)

I would like to achieve a column chart like below depicting the sales and orders side by side with gaps in between. 

[v-xiaotang]

Hi @abner0 

Thanks for reaching out to us.

>> I would like to achieve a column chart like below depicting the sales and orders side by side with gaps in between. 

You can try this visual,

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[abner0]

The above column chart in my example is what gets depicted when I select the 'clustered column chart' visual so they're still side by side