I have a dataset with sales data. I would like to display sales in one table in the way below, ideally dynamically. Sales until 20.6 are the sum of all sales since beginning of time.
Item 20.06.16-20.10.16 20.06.16-21.10.16 20.06.16-22.10.16 20.06.16-23.10.16 Yesterday
Currently I only know how to display
Item Range X
Many thanks for your help!
Sounds to me like you may be able to do this using continuous dates or some calculations. If you share a packaged workbook, we can take a look and try to help.