Sitemap

Amicuk Programming Answers

Using Numbers to sort terms rather than figures or numbers

-0001-11-30   Views:0

Advertisement

Hi folks, I am new to numbers and need a hand. I have a large table of data including company names, expertise, sector experience etc. I am trying to write a formula so that colleagues can check boxes in 2 smaller tables (expertise and sector experie

Hi folks,
I am new to numbers and need a hand. I have a large table of data including company names, expertise, sector experience etc. I am trying to write a formula so that colleagues can check boxes in 2 smaller tables (expertise and sector experience) to produce a list of all the companies that operate in those spaces and then contact them. So, in table 1, I have headings -
Company Name
Company Registration Number
Company Contact
Contact Telephone
Contact Email
Website
Capability Statement
Certifications
Turnover for last 3 years
Insurance Levels
Sector Experience
GB Geographical Experience
Non UK Geographical Experience
Main sector focus
Type
Products/Services
Reference Projects
Other Points of Interest
in table 2, I have check boxes and "sector experience" (all the terms from the same column in table 1 e.g. airports, rail, healthcare and so on)
in table 3, I have check boxes and main sector focus (again, all the terms from column of same name in table 1 e.g. civil engineering, fit out, concrete etc.)
What I would like to happen is, if a colleague checks boxes in tables 2 and 3, table 4 will pull company names and contact details through to the 4th table using info from table 1.
1st off, is this do-able and if so how do I go about doing it?

The replay answer
Advertisement
I would add the two tables as you described AND add two columns to your main table, then use the "Reorganize Panel" to filter the list.
To set this up add the two table for the check boxes:
I gave these table names:
- "Sector Experience"
- "Main Sector Focus"
then added some of the names you provided and set the second column to be formatted as check boxes
Then I added a new column in the main table (highlighted light green) titling those columns the same name with "Filter" at the end
Now enter the formula:
C2=IFERROR(VLOOKUP(B2,Sector Experience :: A:B, 2, 0), "")
select C2 and fill down as needed (I reordered the columns for viewing convenience... move the columns as needed later)
E2=IFERROR(VLOOKUP(D2,Main Sector Focus :: A:B, 2, 0), "")
select E2 and fill down as needed
Now enter names in the vaious columns and check some boxes, then select the main table and open the reorganize panel by selecting the menu item "Table > Show Reorganize Panel":

Go to See the other 9 answers

Using Numbers to sort terms rather than figures or numbers

Category:DefaultRelease time:-0001-11-30Views:130

Hi folks, I am new to numbers and need a hand. I have a large table of data including company names, expertise, sector experience etc. I am trying to write a formula so that colleagues can check boxes in 2 smaller tables (expertise and sector experie[More]

Is it possible to sort by two Key Figures?

Category:DefaultRelease time:2015-10-11Views:130

Hello experts, This is our situation: On a Key figure we have created a condition to display the BOTTOM N by value and by giving it some value which will be never met by within this key figure we’d like to sort a second one to display the TOP N, some[More]

When I sort a column of figures, it sorts by the first digit. How do I get it to sort by the whole number?

Category:DefaultRelease time:2015-10-11Views:130

I have a column of numbers, Specifically: 5.2, 42.0, 25.5, 2.4, 11.8, 0.9, 0.5. Notice how it has sorted by the first digit, not the whole number. In other words 5.2 is ranked higher than 42, because 5 is larger than 4. What do I turn on or off to ma[More]

Sort data by key figure in Query Designer

Category:DefaultRelease time:-0001-11-30Views:130

Hi Gurus, Is it possible to sort a query according to a key figure from Query designer? ThanksUsing condition TOP N is the solutionRead other 2 answers[More]

Sort Key Figure in a Query

Category:DefaultRelease time:2015-10-11Views:130

I have a situation where I have to use a query (not possible to use a view - long story, but limitations on views make it so) I have a simple query that has products on rows, and Month and Sales Value on the columns. I want to sort the Sales value de[More]

Sort descending by a key figure?

Category:DefaultRelease time:2015-10-11Views:130

Hello, This question relates to our Top 10 Vendors query. The default version of the report sorts in ascending order for total invoice value. I can change this from the right click context menu to be in descending order, but I can not figure out how[More]

Can not Sorting by Key Figure with Analyzer and Excel 2007

Category:DefaultRelease time:-0001-11-30Views:130

Hello experts, We have recently changed to Office 2007, and the funcionality of Sorting by a Key Figure with BEx Analyzer is desactivated. We have applied the patch 10 for BEx  BI 7.10. Has anybody had the same problem? Thanks in advanced.Hi Patricia[More]

Sorted by Key Figure

Category:DefaultRelease time:-0001-11-30Views:130

Hi People, I´ve got a query and i need to show the records sorted by a key Figure, for exemplo: Caracterist     -           Key-Figure 100                -              1 100                -              2 100                -              3 100    [More]

Sorting by Key figure

Category:DefaultRelease time:-0001-11-30Views:130

Hi Guys How can I sort the query by a key figure or calculated key figure when I run the query, I know I can do it by rigth click on the key figure after the query is executed but I want the query to be sorted by the key figure as soon is executed. T[More]

Sorting a Key Figure by default in a query

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm trying to set up a query with a key figure that is sorted in descending order by default everytime.  I tried creating the following condition: Key Figure - Sales Volume Operator - Top % Values - 100 This sorts the key figure in descending ord[More]

How can I sort the paragraphs in the New or Edit Cross-Reference dialog?

Category:DefaultRelease time:2015-10-11Views:130

I've got a document with over 100 figures, all are cross-referenced. When I create a new cross-reference I select the paragraph style on the left of the dialog, then the paragraph for the cross-reference. The paragraphs on the right side are not comp[More]

Hot
== Issue == Firefox is crashing or closing unexpectedly == Description == Problem: When I start FF in Linux, it crashes after the cursor is jumping for half a minute. Nothing is displayed. When I start FF from the command line, I get the prompt back [More]
I am trying to feature links on the main section of my tabbed panel page ( http://www.iecaonline.com/benefits-spry.html ) that link to a different tab. I read a tutorial on the labs page (http://foundationphp.com/tutorials/spry_url_utils.php) on how [More]
We use CWBQM transaction to change inspection plan/ multipple spec. As of now we have not implemented change number functionality at inspection plan level. So we don't use change number to change an inspection plan, but because of miscommunication/mi [More]
I want to over write a file, so i used the following ways. with Random Access file only >> RandomAccessFile r = new RandomAccessFile(fileName, "rw"); r.seek(seekIndex) r.writedata.. r.close() << with RandomAccessFile converted to Dat [More]
You see how I like to have my middle window "sized" to have it not hiding behind windows? http://www.ccwatershed.org/media/photologue/photos/444_INDD.jpg Why does In Design not remember my window size, no matter how many times I save the windows [More]
Hi! Can anyone help me with the problem I have on my MWA configuration ? I can see my Devices. Device maintenance --> Device name and I saw it. But I do not have the option delete to erase it if I wan to do it. When I want to create a parameters set [More]
Gradient maps built with CMYK colors in Photoshop don't work correctly in CS4.  For one particular client I often use a brushed steel background. To control color shifts on the press I used a gradient map blending from C0 M0 Y0 K0 to C40 M20 Y20 K100 [More]
I'm new to editing, so this is probably a simple fix. If I open the sample editor the same region loses the pops, but this isn't a real solution.David, Check the language, it should show English North Amercia. Click on the gear icon on the right then [More]
im making this site to showcase my photographs but i having this problem with the navigation,when i click let say in the personal link check some of the pictures then i go to the landscape link check some pictures there then i come back to personal s [More]
Hi All, This has been driving me crazy for 2 days now. I've troubleshooted it down to a problem with the way CFMap is handling a spcific Google Maps API Key. I've gotten it down to about the simpest CFMap page you can make, but the map doesn't come u [More]