Problem with changing order of pivot table

Mon, 27 Jan 2014 15:52:52 GMT

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

topic Problem with changing order of pivot table in QlikView