Hi All,
I've been struggling with creating this report. Our company has 300 stores and we need to report sales everyday, WTD, MTD and Total (YTD).
Currently, we have similar reports but it display one store per page since we group by store. Therefore, it is a 300 pages report.
I need to create a report that will display 3 stores on each page.
The report should look like this.
Store1 Store2 Store3
Date TY Sales Budget LY Sales TY-LY TY Sales Budget LY Sales TY-LY TY Sales Budget LY Sales TY-LY
M Oct 1
T 2
W 3
Th 4
Fri 5
S 6
S 7
WTD
M 8
T 9
W 10
Th 11
Fri 12
S 13
S 14
WTD
.
.
.
S 28
MTD
Total
The report need to group by date, Week, and Month. I don't know how I can display 3 stores at a time on one page with it's data.
Please help!
Thank you very much!
Dninus
I've been struggling with creating this report. Our company has 300 stores and we need to report sales everyday, WTD, MTD and Total (YTD).
Currently, we have similar reports but it display one store per page since we group by store. Therefore, it is a 300 pages report.
I need to create a report that will display 3 stores on each page.
The report should look like this.
Store1 Store2 Store3
Date TY Sales Budget LY Sales TY-LY TY Sales Budget LY Sales TY-LY TY Sales Budget LY Sales TY-LY
M Oct 1
T 2
W 3
Th 4
Fri 5
S 6
S 7
WTD
M 8
T 9
W 10
Th 11
Fri 12
S 13
S 14
WTD
.
.
.
S 28
MTD
Total
The report need to group by date, Week, and Month. I don't know how I can display 3 stores at a time on one page with it's data.
Please help!
Thank you very much!
Dninus