Showing info from differnt tables

Question

Hi,I cannot get this done&nbsp; properlyMaterial&nbsp;&nbsp;Material type&nbsp;Sales&nbsp;&nbsp;MaterialDescription&nbsp;MaterialType&nbsp;datematerialValue123BLUE BIKE&nbsp;123BIKE&nbsp;03-Jun123500124RED BIKE&nbsp;124BIKE&nbsp;05-Jun124530125GREEN BIKE&nbsp;125BIKE&nbsp;07-Jun2231000223BLUE CAR&nbsp;126BIKE&nbsp;09-Jun2251000224RED CAR&nbsp;223CAR&nbsp;11-Jun126500225GREEN CAR&nbsp;224CAR&nbsp;13-Jun2251000226BLACK CAR&nbsp;225CAR&nbsp;15-Jun2261000&nbsp;&nbsp;&nbsp;226CAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Report&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;123BIKEBLUE BIKE500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;124BIKERED BIKE530&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;126BIKE&nbsp;500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;223CARBLUE CAR1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;225CARGREEN CAR2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;226CARBLACK CAR1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;intention is that all materials are in the overview. Description is shown when present, otherwise leave blank&nbsp;&nbsp;Thank you for your helpHans

ryan_mayu · Accepted Answer

hanswittoeck&nbsp;
here is a workaround for you

pls see the attachment below

Forum Discussion

Showing info from differnt tables

1 Reply

Related content

Excel.currentworkbook() not working shows no tables

Blanks showing in table visual

Tables from Dataverse not showing up

Copy Data show Null on Table

Show Subtotal in Table

Material			Material type		Sales
Material	Description		Material	Type		date	material	Value
123	BLUE BIKE		123	BIKE		03-Jun	123	500
124	RED BIKE		124	BIKE		05-Jun	124	530
125	GREEN BIKE		125	BIKE		07-Jun	223	1000
223	BLUE CAR		126	BIKE		09-Jun	225	1000
224	RED CAR		223	CAR		11-Jun	126	500
225	GREEN CAR		224	CAR		13-Jun	225	1000
226	BLACK CAR		225	CAR		15-Jun	226	1000
			226	CAR


Report
123	BIKE	BLUE BIKE	500
124	BIKE	RED BIKE	530
126	BIKE		500
223	CAR	BLUE CAR	1000
225	CAR	GREEN CAR	2000
226	CAR	BLACK CAR	1000