Problem with changing order of pivot table

[#1]

hi everyone,

i have a problem with a pivot table specifically with the native function that allow user to change the order of the column of the table.

If i maintain the column in this order, everything is ok, but if i invert the father and the son the result is uncorrect.

This depends by the formula that is calculate with this script:

if(Dimensionality()=1,

aggr(sum(Qte_A), father)/ aggr(sum(aggr(max(Qte_B),father,son)), father)*1000000,

  if (Dimensionality()=0,

    sum(Qte_A)/sum(aggr(max(Qte_B),son))*1000000,

    aggr(sum(Qte_A), father,son) / aggr(max(Qte_B, father,son)*1000000))

The problems is in the aggregation function that must change as the order of the column.

So there is any function that  relieve the field of the column? or other function as a macro or other?

thank you

Best