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
Click and drag your pivot table to get the layout how you want. See attached.
Also, if you wanted the grey formatting with 'Hol' for Holiday, you could do smthg like this.
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
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?
Sorry, just uploaded it.
Retrieving data ...