Selecting specific values and display in table

[#1]

Hi All,

I want to produce a table containing specific values depending on a selection criteria. I'm currently using the 'Select In Field' button functionality to select a specific range of values which works fine. However, I want to store the resulting values of these selections in a table.

Shown below is what I have at the moment:

Instead of having to click a variety of different buttons to return the results as shown above, I would like to automatically have the results displayed in a table like this:

I have thought about using a script that essentially runs all of the buttons at the same time and places the values in different text objects or having one button that can run the other buttons however I'm not too sure if this can be done.

Any help is appreciated,

Matt

[Anonymous · Accepted solution]

Hi

     You can try the set analysis to determine the specific field value or store value in the variable

     Set analysis is the best solution for your problem instead of selecting the button based on some specific filed u

using the select in field .

Regards

Ashok

[Anonymous]

hi

     Hope this attached file will be helpful for your problem

ex : set analysis

variable =SUM({< Month=P({1<[Month]={'Mar','Apr','May'}>})>}Sales)  --> Only show the total sales of Month Mar,Apr and May

Regards

Ashok.

[#4]

Thanks Ashok,

Set analysis works perfect for my problem.

Matt