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

[sunny_talwar]

Can you share a sample app or data with expected output?

[kaushiknsolanki]

Hi,

All you have to do is this.

Create chart with ID as dimension

and

Sum({<ID = {"2","3"}>}Field1)

as Expression.

Regards,

Kaushik Solanki

[sunny_talwar]

Hi Kaushik,

Doesn't it seem based on his current expression that he want the output to be based on selections? You might be totally right, but I am not sure what exactly he is looking for.

[kaushiknsolanki]

You are right Sunny.

I just gave the expression for him to understand, how subset of the data can be obtained easily.

If he needs based on selection, then I would like him to try his hands first before asking the question, because its simple logic...let him try and in any case community is always available for him.

Regards,

Kaushik Solanki

[Anonymous]

Hello,

My problem isn't as easy. In my problem real, I don't know the IDs that's why I make a set. I have the set and I should do my table with this

Regards

[sunny_talwar]

[luciancotea]

Are you trying to compare two sets of ID using Alternate States?

[kaushiknsolanki]

Dear Jonay,

Can you please post the sample application and explain your problem in detail, like what you have and what you need as output along with the logic.

Regards,

Kaushik Solanki

[Anonymous]

Hello everybody,

I am trying make a table with some values of ID. I need to show only some values. I add a example

It isn't my real example, but I hope to explain my problem

I have 3 fields, ID,A and B. I need to show Only({<A=-{"x"}>* <B=-{"x"}>}ID).  I would like to show only ID = 3,4

My table will be the next:

ID    sum(valor)

3        300

4        400

¿Do we understand me?

Regards