Product Sales History

From DataSelf Knowledge Base
Jump to navigation Jump to search

Major dimensions, such as the Product in the Sales data source, include a list of all the products, even if there are no sales records for that product. In the case of no sales in history, the Invoice Date and related customer, etc, are NULL.

Items with NULL in the measures are automatically filtered out of the report. Therefore, we need to make special calculated measures to convert NULL's to zero. And all dates(including NULL date) need to be included to insure that all products are listed.

Attached is a workbook (that you can open with DSA Desktop), with calculated measures that allow the product sales to be listed for the last two years, as well as a Total for all time. This example gives one way of doing inventory history that includes items that were never sold. This type of report is often used as a base for future sales projections.