Would you please share How data is populating in your Database( If Data is not sensitive, Then mock up your situation then attach TWBX).
Thanks for responding, I've stripped the data down so it just the dates, order number and item numbers.
I can get the results I need via excel and using formulas like COUNTIF,IF and SUMIF.
I'm hoping I can replicate in Tableau.
Any suggestions will be much appreciated.