Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi.
i would like to do the following in cross tab
Product | sales1 | sales2 | sales3 | sale4 | sale5 | sale6 |
100 | 200 | 350 | 120 | 200 | 500 | |
400 | 100 | 450 | 210 | 300 | 100 | |
500 | 300 | 150 | 321 | 400 | 100 | |
total | 1000 | 600 | 950 | 651 | 900 | |
totsales for next 3 months | 670 | 820 |
totalsales for next 3 months = current total sales+total sales of next two columns.
I used after of function and it didnt work. can anyone help?
Regards.
siva
After function will work only on pivot table not for stright table.
Yes, can you please let me know how to achieve this on pivot table.
I hope accumaltion resolve ur prblm.