ordering columns in a pivot

[MattRichardsUK]

Is there a way of hard coding the order of colums in a pivot, depending the the value returned by the result set eg.
if result = 1 then
column order = 12345
else if result = 2 then
column order = 54321

 

[lennondad]

Assuming you are using Brio 6.5 or above, you should be able to use some Javascript on the Postprocess() method to apply the sort to the Pivot.

e.g.

ActiveDocument.Sections["Pivot"].SideLabels["Dummy"].SortByLabel(bqSortAscend)