Hello. I'm working with some data and pivottable. I'm looking at the fields and most of the fields I can identify, but there are a few that I don't know where on earth they come from. Is there a way I can click on the field and find it's cell reference. Obrigado.
You get better and quicker help, if you follow the advice in the link below.
http://www.excelforum.com/the-water-...-question.html
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
It's a pretty basic question....Not really a need for a spreadsheet. I'll repeat it: When you have fields in a pivottable where can you find the source for the specific fields (not just the source for the entire pivottable).
Right click -- Show field list
Fields are just the column headings based on the range of your pivot table
Life's a spreadsheet, Excel!
Say thanks, Click *
If you have a field in the list that you cannot find in the source data, it is a Calculated Field. If you select Options in the PivotTable Tools group, then click 'Fields, Items and Sets' and List Formulas, you will get a new sheet with a list of the Calculated Fields (and Items).
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks