How do I exclude data from a range or table when creating Pivot Tables?

Question

I am new to the excel community, so I hope I'm able to explain what I'm trying to do. I have a grid of information, and I'm trying to pull specific info from this grid to a pivot table, so when I double click on the cell with data in the pivot table, it'll show me the information from that specific item in the grid. For example, I have 6 columns on worksheet 1 which my pivot table is pulling the data from. Column C shows the date the order needs to be delivered by. Columns A, D and F are also columns with data I want to include when choosing the range of data to analyze, but I can't seem to exclude columns B and E without deleting them. I want only A, C, D and F to show when I double click the cell in the Pivot Table. I've tried choosing only the columns wanted with a comma between each when choosing the Pivot Table data source, but it says Data source reference is not valid. Any pointers would be appreciated.

Answer 1

1. Remove th columns in raw data and create a poivit table. Then after double clicking the value, it will show ACDF directly.
2. Use CHOOSECOLS function - Microsoft Support to get the result from your previous result from povit table.

=CHOOSECOLS(Your range of data from povit table,1,3,4,6)