The Power Pivot add-in allows you to make different calculations depending on the time period in which the sales occurred, by writing formulas in DAX language. To use these features you need to have one of the latest versions of Microsoft Office Pro Plus. Since many do not have this feature, it remains only to deal with the traditional lookup functions about which application I’ll write in following „recipe“.