Running average needs to be specific for each Branch code
Could you please guide me to fix the running average (Net claims) for each BR Code separately. In other words after seven months the total row should carry the average total & for the next Branch it should start again from the Jan figure of the said Branch etc.
Thanks sunny, That is fine. Also will you suggest how I get the total row arranged in total average. Right now it is in blank. If Aggr to bring in how the string to be arranged. Eg AS Total should be Rs 3,003,852