Chart with week & weekday as a dimension

[guya]

Hi all,

I need to create a chart with week number and weekday as a dimension and two expressions counting the number of receipts (this and last year).

Pls find enclose a sample.

Does anyone have an idea

Thnks,

Guy

[#2]

Click and drag your pivot table to get the layout how you want. See attached.

[#3]

Also, if you wanted the grey formatting with 'Hol' for Holiday, you could do smthg like this.

[guya]

Thx a lot Rebecca... that is very helpful

Any idea how to keep only business days (hide Sunday and Saturday) ?

I'm also trying to create a bar chart like on the sample2 but bars keep stacked even if I select 'Grouped' in the subtype style.

With many thanks

Guy

[#5]

You can keep it to Mon-Fri by adding that to the set analysis. See attached.  For the bar graph you mentioned, what sample2 are you refering to?

[guya]

Sorry, just uploaded it.

thx