pivot report calculation fixes