As you can see this is the Pivot - no data is given that means anything.
When I add AccName it appears under the (+) but I need to add it as a separate column. When I try to do this is tries to make it a calculation (avg, sum, etc) - how can I add a AccName column (existing field) that just shows the field data for that record in a column or even link to that column.
Bottom line is that I need to show the AccName based on a search on the Account (top) and Date. I was going to use VLOOKUP to do this task but without the AccName coumn I cannot figure it out.
Capture.PNG
Bookmarks