selecting in field according to an 'IF' condition

[shayraber]

Hi all,

I'm facing an issue which I haven't been able to solve or find a solution for up until now.

(It's a bit long to explain...)

I have a field of stores (among many other fields) and data from several years at the document.

Not all the stores were open all the time so let's say I have 20 stores on 2012, 25 stores on 2013 (6 stores opened and one closed) and 28 stores on 2014 (no store was close and 3 new stores opened)

I want to present table of store's performance related to other and compared to previous year.

The easiest way is to show the set of all stores which was open this year and previous year and compare their performances.

What I wish to do is an analysis which will show only the common stores of both years (the performance of stores which opened or closed this year will not be considered).

Until this point – things are working just fine. The issue starts when I want to be able to select that set of values (common stores).

  I want that the set of those common stores which were operational this year and previous year will be selected for further analysis. The stores field contains all possible stores records but only 25 of them are relevant while comparing 2014 to 2013 for example. How can I get to make that selection by an action/button/macro etc. WITHOUT acctually select those values.

i need those values to become "highlighted in green" automatically and without selecting them one by one

thanks in advance for your help

Shay

[shayraber]

hi

Iguess I didn't explain myself good enough.

having an object which compares the performance of stores 11,12,13,16 (the common stores for the datat i generated) is somthing I already have.

what i'm looking for is a way to create a trigger/button/action/macro etc. which will cause the actual selection of those stores (11,12,13 and 16).

i can, of course, physically select those stores BUT i'm looking for an automated action which will do that and will be triggered by 1 click.

i want to give the user the ability to choose only those stores without forcing him to actually choose them one by one (since that the real data contain tens of thousands of records...)

the set analysis i'm using is, of course, more sophisticated and i'm NOT looking to create an object. i'm looking generting a field selection according to that logic

[tresesco · Accepted solution]

Created a button. PFA. Is this what you want like?

[shayraber]

great!

thanks a lot