Hi
I have the below data and need to be able to show the total for certain dates in each month, for example for February I want to show the first 15 days total while still showing the full total for january. I have tried to insert slicer with day in it but once I select the first 15 days it selects the first 15 days for both January and February.
Sample data below
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have the below data and need to be able to show the total for certain dates in each month, for example for February I want to show the first 15 days total while still showing the full total for january. I have tried to insert slicer with day in it but once I select the first 15 days it selects the first 15 days for both January and February.
Sample data below
| Store | Castlebar | ||||||||||||
| Column Labels | |||||||||||||
| Values | January | February | April | May | June | July | August | September | October | November | December | Total | |
| Sum of 2018 Sales Values | 30 | 15 | 47 | ||||||||||
| Sum of 2019 Sales Values | 2000 | 15 | 2017 | ||||||||||
| Sum of 2018 Sales Returns | 60 | 30 | 94 | ||||||||||
| Sum of 2019 Sales Returns | 3000 | 30 | 3034 | ||||||||||
| Please Help! Thanks in advance | |||||||||||||
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
