The source data in the table - does it have fields like Customer, Week and Balance? Is the Week a numeric field, so we are now in week 6 of 2016, or is it a date like 10 Feb 2016? Is the level of detail set so there is only one row per customer per week, or are there sometimes more transactions for a customer in a particular week?
And I guess you want something which will run again simply next week, and the next week and so on, without needing to update the S value each time?
We have a guest column , the balance is actually a measure ( Sum of Mount of invoice ) we control the amount we have a date column ( type date) that we use to different calculated columns (weeks, months , etc ...)
Yes there are sometimes several transactions per week per client.
We actually evil in our summary has to appear for example some columns with the Sum of mount Week 4 , 5 and 6 followed by a column that shows the Sum of Mount of command
Je suis désolé, mais je ne comprends pas exactement la problème. Si vous voulez, envoyez moi un mail à email@example.com, comme ça on peut échanger des images, des données et des modèles.