I have a pivot table in QV and I need to format the alignment of the headers, but I can't figure out how to do it.
To further complicate matters a tiny bit, the headers come from a valuelist, so all the expressions that are populating the values have pick functions to populate the value list. (I don't know if this makes much of a difference, but the only other help I've seen that relates to this was very old and talks about using blank character fields to space things out which just doesn't seem appropriate in this instance - and I couldn't get it to work anyway when I tried it!).
At the moment it's left aligning the headers and right aligning the data below them - I don't care how they're all aligned as long as it all matches up under itself and I can't believe there isn't a way of making it do this!
Any help you can give me would be very much appreciated,
Ian
