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
Note: we are not talking about zoom to fit for pdf, etc but ONLY about zoom to fit for jpegs and similar graphics files. The problem: starting with Snow Leopard if you have a small picture in actual size but expand the window then click zoom to fit t [More]
Hi ALL, i am working on a requirment for OS commands i have some doubt in this.we have a file sender FTP system in unix ,i am writing a shell script to find a file . 1)My doubt is where shoud i deply tht shell script ,is that in the PI systems server [More]
Hi, In report 6i it is showing following error occured for particular supplier_ no(say 58).The report is working fine for all the other supplier_no giving in the parameter form. The error is " Rep-1401 cf4_formula fatal PL/Sql error occurred ORA-6502 [More]
Hi I have a Nokia 820 - it is a great phone and I love it.  I have had it for the last 6 months but I noticed a couple of things lately. When I use the camera and take a picture, sometimes the screen blacks out and you cannot take another picture wit [More]
In Bridge CS6 when I loaded images from my Canon camera shot in Raw but with the Monochrome pic style, it retained the thumbnails in black and white. That is perfect ! How can I stop Bridge CC from changing the Raw back to their default ? Help please [More]
Hello, I have question regarding updating SE apps. 1. From what I understand you can still create single edition apps for ipads after May 1st with a pro account, correct? 2. If I create an app now, with my CC account, can I later, after May 1st, crea [More]
To make a long story short, I made a complete backup of my computer to an external hard drive. I erased my entire computer and reinstalled the system. When I tried importing my iPhoto library, for some reason I now have three versions of every photo. [More]
Why can't I pair my iphone 4s to another iphone 4s via bluetooth like any other brand phones?? What app do I need to install?BYou keep dwelling on the "how" - Bluetooth. You still have not told us the "what" - what are you trying to do [More]
I recently bought a new phone - Samsung 740. I would prefer not to buy a data plan but just sync my calendar to my MacBook Pro. When I ask if this can be done at the Verizon store, all I get are blank looks. They sell a USB cable but have no other ad [More]
I have a iphone 4s, at first i had No Serivice then i removed the Sim Pin,after that i got service but no 3GBased on the very limited info you provided in your post:  Settings > General > Reset > Reset Network SettingsRead other 4 answers [More]