Hi,

Recently in of our product offerings we got stuck on this following question:

How to Sort Dimension based on the Order Value which Keeps Changing with Factual Values??

We have a data source laid out as (example)

In the above the Order columns are changing per Company/(DimensionA) for DimesnsionB.

Instead what we want is: (But only if we can get the following result without putting the Order Column in the Values Section. 

If there are any configurations that we can make to our power pivot model for the similar data set so that the DimesnionB in this case can be sorted by the Order column, would be greatly helpful to us. 

Sample File:

http://tms.managility.com.au/query_example.xlsx

Thanks

Amol 

Hi Amol,

You can sort a colum by a value from a different column within the same table:

In the Home-tab of your PP window - sort&filter-section - sort by column, click the little triangle

But this requires unique entries in the column to sort by.

In your case, this uniqueness could dynamically be created like this: Create a lookup table where you translate every Dimension A into a unique number. Fetch this value into your table, multiply by 100 (next highest decimal to the highest entry in your order column) and add it to the order-column.