Getting Values from 1 control and use it in anther

[#1]

Some one please help!!!

I had a existing Straight Table in my report which display the Top N Numbers of customers based on their purchase.

Now I'm adding another straight table to display customer preference. my new control should:

1. Only display customers which appear in the existing straight table
2. the Display ordering should be follow the straight table.

For Example:

Existing table:

Customer	Total Sales
A	200
C	210
D	220
E	230

My table should display:

Customer	Setting
A	Setting 1
A	Setting 2
A	Setting 3
C	Setting 1
D	Setting 2
E	Setting 1
E	Setting 2

When selection change and control display:

Customer	Total Sales
E	130
A	100
D	120
B	130

My table should display:

Customer	Setting
E	Setting 1
E	Setting 2
A	Setting 1
A	Setting 2
A	Setting 3
D	Setting 2
B	Setting 1

Is there a way for me to get a control's data and sorting order???

[CELAMBARASAN]

What is the sorting option you are using in existing straight table? And how it displays the customers?

[#3]

The default sort order is desc on the total sales but the calculation of the total sales is complex.

[CELAMBARASAN]

Refering the object from another object is not possible.

Try like this

Copy the expression Existing straight table and add it to the Preference table. In presentation tab, select the expression and mark it as hidden.

Sort tab, do the same sorting for the expression which you did for the first table.

[#5]

I did this. but the problem is my total value sum up is different from the existing table.