How to sort horizontal pivot table with 2 dimensions

eliko_il — Thu, 19 May 2016 07:02:43 GMT

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.

The final sort that i want to get is:

yyy

xxx

rrr

zzz

ttt

and to hide the second expression from the pivot table.

Re: How to sort horizontal pivot table with 2 dimensions

eliko_il — Mon, 23 May 2016 14:38:27 GMT

Hi,

Any idea how to solve this problem?

marcus_sommer — Tue, 24 May 2016 07:16:43 GMT

- Marcus