Set Analysis with nested IF

[pete_bolin]

Hi everyone, looking for a little help with set analysis. Any help would be greatly appreciated. Thanks so much!

I'm trying to sum sales for each day of the workweek (mon - fri).  So for each day, I want to sum the sales for that day and place it in a column.  So in this example, the next column would be the 17th, 18th, etc for the week. 

Here is my formula which is not working. 

Sum({$<[SALE_DATE] = {$(=IF(weekday(today()))=2)}>} SALES_COUNT)

[eliko_il]

Hi,

In this case you don't need to use set analysis.

Choose pivot chart and add the day as a column, which make the day to appears horizontal in the chart.

Final ,just use simple sum expression without set analysis.

[pete_bolin]

Thank you for the reply. I did think of that, but I need to email this out on a daily basis via NPrinting. Pivot tables don't look good in a report and users complain. So, I try to keep it to a tables. But I may have no option in this case. Thanks again! Cheers!