Automatic sorting in Straight or Pivot table

[hopkinsc]

Hi,

I need help!!

Is there a way of stopping the automatic sorting when i select a value within a straight or pivot table?

I have a Straight table with transaction header details,

i.e.

RETAILER NAME, TILL NO, TRANSACTION ID, EMPLOYEE NAME, DATE, TIME, SALES AMOUNT.

As the user scrolls through the table to look for a transaction, when they find it and select it, another straight table appears showing the products bought, price, qty etc.

The problem i have is that as soon as the user selects the transaction they wish to look at (in the header), all other header details dissappear and the one selected moves to the top. If the user then wants to look at the next transaction, they have to start back at the top and scroll back down.

I am wondering if there is a sort expression i could use to stop it from changing so that the user could select one after the other without having to scroll through the list again.

Can anyone help please ?

[syed_muzammil]

Hi,

Check the Preserve scroll position in chart Properties--> Layout.

Regards,

Syed.

[#3]

Hi,

Here you are a possible solution, check out the option show all the values on the Dimension and the Order sentence, It will keep all the records and you never lost the position.

I hope it helps you.

Regards.

[hopkinsc]

Hi Miguel,

Can you explain what the sort expression in your example means please?

I need to tick 'Show All Values' on my TRANSACTION ID dimension, but am unsure what to put into my sort expression as i have around 7 different dimensions.

[#5]

hi,

the sort expresion "=sum({<Data=>} Value)" means that order of the data omits any selection on the field Data and keeps the order based in the Sum(Value) allways.

Regards.

[#6]

Perhaps you can try

Right Click on Pivot Table properties -> goto general Tab -> check the "Detached" checkbox

Do this for those table you want to make it static.

Hope this help, or hope i didn't misunderstood your situation

[#7]

Thanks man, worked for me.