I am attempting to automatically pull data from a pivot table. The numbers I am trying to extract are sums which correlate to an account number, but in addition to the account numbers (which repeat) they are also broken down by 2 more layers of sorting that also need to be extracted. Ultimately, I am trying to build a table that sorts the data by these three ID numbers. I tried using GETPIVOTDATA but was unsuccessful. Does anyone have any suggestions? Thank you in advance for any help.
Unit Invoice Number Invoice Date Account Number Description AMOUNT
RALBR-310 3154192364 72400 $107.38
RALBR-310 3154192365 $39.15
RCLIF-310 3154192366 $84.48
RCLIF-310 3154192367 $107.95
Bookmarks