2 Replies Latest reply on Mar 29, 2017 2:27 PM by Deepak Rai

# Show weekday sales at the end of the week

Hi All,

I have a daily wise data of sales and I want to see total sales of everyweek at the end of the week for that particular month (for ex: on Saturday I want to see the total sales of Monday, Tuesday, wednesday, Thursday and Friday) or so on and also I want to see my weekday (Monday, Tuesday, etc) sales as 0 instead of real numbers.

I am taking my date (daily) field on my report as well.

Please find the attached sample data. Looking for calculation.

• ###### 1. Re: Show weekday sales at the end of the week

Kumarc

I'm not sure I understand your request correctly or not, anyways.

[Datetrunc]

date(Datetrunc('week',[Date],'Sunday'))

[Last Date of Week]

{fixed [Datetrunc]:max([Date])}

[Sales Sum]

if [Date]=[Last Date of Week] then {fixed [Datetrunc]:sum([Sales])} else 0 end

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Show weekday sales at the end of the week

Hi Kumar,

Have a look at the screenshot and attached in 10.2.

You have to first Divide your dates  into weeks and then from there you can use FIXED LOD to get Weekend Total. There are few intermediate calculations to give an Integar number to day weekwise. You have 31 Days to a max in amonth, so if first you divide them into different weeks, then it is easy.

1 of 1 people found this helpful