sorry for this terrible title, could'nt find a better one …
Important point : im using jet express instead of jet essential BUT I don't think it's an issue here.
im working on a report who shows the Amount, Profit, and the Profit per Gen. Prod. Posting Group for each Vendor as shown as below.
im facing problems with the columns. I don't know how to divide the data per week from week 1 to 52 and show the first day of each of this weeks.
If anyone could help me, it would be much appreciate.
kind regards
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment I find out how to solve this problem :
first you put the "Order Date" into the line of your DCT
then you can group them by Day, 7days for a week
then you switch the "Order Date" from line to column
problem solved, thanks to the Internet
Please sign in to leave a comment.