Forum Discussion
rservice0320
Apr 07, 2022Brass Contributor
pivot table summing %'s
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
- rservice0320Brass Contributorsent the wrong file. this guy actually works when I limit the BU to one area