Day breakup templat

[Former Member]

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

[amitrathi239 · Accepted solution]

Hi,

Pull the one month data in the report and from the date object display only Day part.For this type of requirment use crosstab.

=Formatdate([Date];"dd")

Amit

[Former Member · Accepted solution]

Hi Amit If we use cross tab, then last two columns will not be  possible isn't it? last two columns is two separate field

[Former Member · Accepted solution]

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