Expression to include previous year Sales

[#1]

Hi All,

The required calculation is

Flow% = Sum(A) for the current Year / sum(B) of the previous year.

Can you please help me in acheving this keeping Year as Dimension. How can i acheive this in a Pivot table.

Flow% = Sum(A) of Tn / sum(B) of T(n-1)

[sunny_talwar]

May be this:

Sum(A)/Above(Sum(B))

[sunny_talwar]

Or even better, try this:

Sum(A)/(Above(Sum({<Year>}B)) * Avg(1))