Hi
I have a pivot table looks like this, prob is when i sort it by currency it won't work, it blinks for a minute like it is doing something but doesn't sort by currency.
ie i want it to put all the GBP stocks together, i know i can manaully do this but i would like it to update automatically when refreshed. Please help. thanks

type name ccy holding price amount
Equities Baa GBP
bat GBP
zara GBP
BA GBP

amn USD
grd USD

mmm GBP