I'm after writing a report that shows sales for all deaprtments and catergories, even those that haven't got sales. This is because i want to link to a table with forecasts and although you may have a value in the forecast you may not have taken any sales for it.
I have tried all combinations of joins but only seem to be able to get the report to show departments and categories that have taken sales for the period selected
I'm after writing a report that shows sales for all deaprtments and catergories, even those that haven't got sales. This is because i want to link to a table with forecasts and although you may have a value in the forecast you may not have taken any sales for it.
I have tried all combinations of joins but only seem to be able to get the report to show departments and categories that have taken sales for the period selected
Have something to add? Share your thoughts — no account required.
Ask the community — no account required