How to sort horizontal pivot table with 2 dimensions

[eliko_il]

Hi ,

I need help with the following problem:

This is my pivot table:

First dimension : Year-Month

Second dimension : Part Name

First Expression:

sum([Inventory Qnt]) + RangeSum(Before(Total sum([Inventory Qnt]),1,ColumnNo(Total)))

-

(sum([Forcast Qnt]) + RangeSum(Before(Total sum([Forcast Qnt]),1,ColumnNo(Total))) )

Second Expression:

fabs(

  sum([Inventory Qnt]) + RangeSum(Before(Total sum([Inventory Qnt]),1,ColumnNo(Total)))

  -

  (sum([Forcast Qnt]) + RangeSum(Before(Total sum([Forcast Qnt]),1,ColumnNo(Total))) )

)

/

Factor

The probelm:

I want to sort the Part Name by the Column number of the lowest value of the second expression.

For example in the picture above i mark the lowest value of the second expression per Part Name

and write the column# above.

Part Name	Min of second expression	match column#
yyy	1.25	1
rrr	3.75	5
zzz	9	5
ttt	2	10
xxx	7.5	1

The final sort that i want to get is:

yyy

xxx

rrr

zzz

ttt

and to hide the second expression from the pivot table.

[eliko_il]

Hi,

Any idea how to solve this problem?

[marcus_sommer]

Have a look here: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

- Marcus