Selecting Values From A PivotTable and Reformatting From the Original Sheet

You would need to attach a sample workbook showing what you have and what you are trying to achieve mocked-up.

Go Advanced -> Manage Attachments -> Upload

I have attached an example xlsx document in the original post.

In essence, I'll have one sheet that will have a ton of fields, calculations, etc., a pivot table that highlights all of the possible new pricing options an end user can select from, and then I need to recompile to a report that will need to bring fields back in from the original sheet.

So my question remains can users select information on a pivotTable in a manner that links it to the original row the information is being pulled from?