The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
I am trying to determine how many orders are print only, digital only and digital and print.
Example table looks like
Order Number Title Cost Meditype DateIns
1234 PB £50 INT 01/01/2017
1234 PBA £20 PRINT 01/01/2017
2345 TA £5 PRINT 03/02/2017
9999 NS £40 INT 09/02/2017
So DUEL = 1 , INTERNET = 1, PRINT=1
How could I achieve this? Help appreciated.
Anyone any ideas?
Help still required.......