Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.......