Day breakup templat
If we want to develop the below day breakup template as shown below
How to approach, is it we have to create 31 filters for individual day, any best practice available
Create the cross tab with Day(=Formatdate([Date];"dd")) and SKU.
Then click on Sum function to get the MTD sales column and change the formula as needed.
Then insert a column to the right for MTD target column.