My pivot table is summing the current AR%. If I exclude it from the pivot & try to insert a calculated field it won't allow me because my "data type" isn't specific to acct receivable & sales. Been racking my Excel brain, so help would be greatly appreciated. The index / match works beautifully thanks to Hans!!
