Table with a data set

[Anonymous]

Hello everybody,

I have a problem and I don't know the solution. I like to do a simple table with a ID and other calculates

ID  Sum(field1)  sum(field2)

I have many ID but I like to have only a set of these, for example

ID  sum(field1)

1  1000

2  3000

3  4000

4  1000

I like what my table shows ID = 2 and 3. I would like the next table:

ID  sum(filed1)

2     3000

3     4000

In my real example, I make a set :  only({(<field2 = $::field2>) - <IDA= $::IDA> * (<field1 = $::field1>)}ID)

but I'm not as to do what my table only shows the IDs of the set

¿How can I have my table?

Sorry for my bad English

Regards

[kaushiknsolanki]

Hi Jonay,

Sorry I am still confused on what you need.

It would be great if you can create some sample data ans share with us.

Regards,

Kaushik Solanki

[Anonymous]

Hi!

If I make the tabla, It will be

ID         sum(valor)

1             100

2              200

3              300

4              400

5              500

6              600

But I need to show, the Ids that is in the set

The resulting table what I hope is

ID         sum(valor)

3              300

4              400

I don't like to show all ids. I like to show only the Ids of set

Regards

[kaushiknsolanki]

Hi Jonay,

I understood that you want to show some of the ID's from the entire list.

Now tell me on what basis you will select which ID's to be shown.

Do you know that you have to always show only ID 3 and 4 or is it something depended on some values of some other field?

Regards,

Kaushik Solanki

[sunny_talwar]

May be this:

sum({<A=-{"x"}>* <B=-{"x"}>}valor)

[Anonymous]

Hi Kaushik,

I shouldn't show only ID 3 and 4, It depends. I did this easy example for to explain my problem. I would like what have been selected the values of the set. Maybe ID = 3,4 or ID 1,2, or other. It depends the others condition. If I make a set , ¿is possible to show the ids of the set only?

Regards

[kaushiknsolanki]

Dear Jonay,

The expression which is used in the example I gave is based on the Set only, but on what basis you will defind the set is what I am looking.

You said that "Based on Selection", So do you mean that Whatever ID's are selected by user should only be visible?

Regards,

Kaushik Solanki

[Anonymous]

Hi!

The user don't do selection. The file is reload automatically and I create a report. I have some tables and It share a field ID. I make a set what select ID These Ids are in both tables.

In the easy example:

Only({<A=-{"x"}>* <B=-{"x"}>}ID)

In the real example, It is more difficult, but I have the Ids. I make a set and I need what this set will be the values showed

Regards