I have an *.xml file on a PC running Windows XP, with a structure something like...

<movies id="my movies"
  <movie name="Unforgiven"
    <people star="Clint Eastwood" director="Clint Eastwood"/>
  </movie>
  <movie name="A Fistful of Dollars"
    <people star="Clint Eastwood" director="Sergio Leone"/>
  </movie>
  <movie name="J Edgar"
    <people star="Leonardo DiCaprio" director="Clint Eastwood"/>
  </movie>
</movies>

I want to open this file in a viewer utility which will show one line per movie, filtered by a condition such as director="Clint Eastwood", including the relevant value for movie name on each line.

Note - that's just an example. My actual file has thousands of lines, each possibly several hundred bytes long, and there are many more levels and named values. The important thing is I want to apply a filter for a specified value of some field at some level. And I want to see one line for every case where that value occurs, showing the values for any fields I specify, even if they're stored at higher levels.

I may be mistaken in saying what I want is a "pivot table" - I don't know what I should call it.