cristianivanoff
Technical User
Hello All!
I have a table with these fields: {Period},{Paym},{Prodcode}
My cross tab:
Period1|Period2|Period3 etc
Prodcode1
Prodcode2
..
..
In the summarized fields I have the sum of {Paym}.
In period3 I want to show the result of [period3+period(3-1)+period(3-2)]/3. The same goes for period2 and all other periods.
Any suggestions how to solve this?
I have a table with these fields: {Period},{Paym},{Prodcode}
My cross tab:
Period1|Period2|Period3 etc
Prodcode1
Prodcode2
..
..
In the summarized fields I have the sum of {Paym}.
In period3 I want to show the result of [period3+period(3-1)+period(3-2)]/3. The same goes for period2 and all other periods.
Any suggestions how to solve this?