Forum Discussion

rservice0320's avatar
rservice0320
Brass Contributor
Apr 07, 2022

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

  • rservice0320's avatar
    rservice0320
    Brass Contributor
    sent the wrong file. this guy actually works when I limit the BU to one area

Resources