hi to all...iam creating every month 3 columns(one is year target and cumtarget and monthly achivmnt....
i calculate april to march and also i consolidate every month consolidation of .
in april
ex:YT=120 CT=10(sum of YT/12)*1 MA=9
in May
YT=120 CT=20(sum of YT/12)*2 MA=10
in june
YT=120 CT=30(sum of YT/12)*3 MA=12
then iam creating year consolidation table same as YT CT MA :
i retrieving MA using sum of every month,bt CT was Increasing every month when i want to recent month of CT value only displayed in consolidation table so plz help me how can i consolidating.
im using excel worksheet