Deb,

Seeing that this is mult-tenant cloud, the options may be very slim. Normally, I would look to create a custom SQL view in X3 to pull in some of the financial data but be grouped by "Week" which would be something similar to this: GROUP BY DATEPART(week, TransactionDate) and also have to use a DATEFIRST setting to pull in the week numbers associated to the data you have grouped. 

You could also attempt to add a SQL query within the view to attempt to group this data by week, not sure how successful that will be but worth a try!. 

Deb,

Seeing that this is mult-tenant cloud, the options may be very slim. Normally, I would look to create a custom SQL view in X3 to pull in some of the financial data but be grouped by "Week" which would be something similar to this: GROUP BY DATEPART(week, TransactionDate) and also have to use a DATEFIRST setting to pull in the week numbers associated to the data you have grouped. 

You could also attempt to add a SQL query within the view to attempt to group this data by week, not sure how successful that will be but worth a try!. 

Thanks Rafael - not sure I can write that in SQL - still trying to learn.  I may just wait until they get their SEI upgraded to V9 as v8 is very buggy in the cloud.

Yes, V9 is more stable infrastructure. Shoot me an email, I'd be happy to help write the SQL script if you need it. :)

thanks - just getting started with SEI training for this customer.  I'll email you. Appreciate the help.