Set analysis Sum Sales two days into one day

[Peter_Brunner]

Hi All,

I have been trying to add Saturdays sales into Mondays Sales but NOT show Saturdays sales Date on Graph. I have been using syntax below with

Mondays and Saturdays sales showing have tried several combinations but still no go. any help would be appreciated

if(Calendar_WeekDay ='Mon'or Calendar_WeekDay ='Sat' ,Sum({$<BusinessArea={[Building Supp]},Calendar_WeekDay={'Sat','Mon'}>}SalesValue))

regards Peter

[kaushiknsolanki]

Hi  Peter,

     I would recommend you to create a seperate field in Script which will show Monday in front of sunday and then use the field in chart to show the data.

     Something like this.

     Load if(wildmatch(Weekday(Date),'Sat*'),'Mon',Weekday(Date)) as New_WeekDay.

     From xyz.

Regards,

Kaushik Solanki

[somenathroy]

Try  with this:

if(Calendar_WeekDay ='mon'or Calendar_WeekDay ='sat' ,

Sum(TOTAL{<BusinessArea={[Building Supp]},Calendar_WeekDay={'sat','mon'}>}SalesValue),

sum(SalesValue))

Regards,

Som

[Peter_Brunner]

Hi Kaushik,

thanks for your help I did use it at script level but it still showed Saturdays I changed the dimension to a field to only show Selling Day Dates. 

also thank you Som for your help

regards Peter

[kaushiknsolanki]

Hi,

     Have a look at the attached example for more clarification.

Regards,

Kaushik Solanki

[Peter_Brunner]

Hi Kaushik,

first thank you for reply

Yes this works for the Days of the week.

I need it to be Date driven so I can show all selling dates for current month in graph.

if you select from your Dates list box the 2/3/2013 which is a Satuday and then select 4/3/2013

which is a Monday it does not add Satudays total to Mondays but if you do via weekdays it does

Peter

[kaushiknsolanki]

Dear Peter,

       If you select the dated then you will not be able to see the bar chart.

       Will you please tell us why you want to have this on date selection basis? when you can have that on weekday basis.

Regards,

Kaushik Solanki

[Peter_Brunner]

Hi Kaushik,

sorry for late reply, and thank you for your help.

The reason I need dates is the Sales graph I am doing is by Month and I need to show all the working days or "Dates" in graph.

Sorry it is my fault I did not explain it properly, but I have it working now.

Best regards Peter