Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Day breakup templat

Hello,

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


replied

Ben,

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.

-Sri Harsha

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question