pivot table summing %'s

Contributor

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!!

1 Reply
sent the wrong file. this guy actually works when I limit the BU to one area