FORMULA IN LAYOUT

[#1]

I HAVE A COUNT 3 CALCULATES FORMULAS THAT WORKS FINE.

I CALCULATE NEW SUPPLIER, LOSSER SUPPLIER, AND PORTFOLIO.

NOW I WONT TO NOW THE CHURN OVER THE YEAR.

BASICALY IS IT.

PORTFOLIO IN FIRST WEEK OF THE YEAR / ACCUMULATE LOSSER IN THE YEAR TO ACTUAL WEEK.

My problem is for the year before. how can i do it in the pass. right now I put the first week of the year in a variable.

and y count the portfolio in first week of year /

/

count with set anayliss week >= firstweekof year (variable) and <= actual week (variable) losser supplyer.

Thanks in advance

[Gysbert_Wassenaar]

In a chart expression you can often use the above() function to retrieve the previous value of column. See the help file for detail. Or post a sample document with some data and an explanation of what the result should be.