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
Hi , I am having problem loading the data from PSA to write optimised DSO I have changed the normal DSO into a Write Optimised DSO. I have 2 data sources to be loaded into the write optimized DSO. One for Demand and one for Inventory. The loading of [More]
Hi everyone, I'm noticing some strange behaviour of my iPhone 3G's audio on the O2 network here in the UK. Both O2 & the iPhone are new to me so I don't know which is the cause, but was wondering if anyone else has experienced this 'problem'? What ha [More]
Hello All, I am using the PCI-7342 to control 2 servos for co-ordinated motion. I am using UMI7764 to breakout Motion IO to connect to my Servo Amplifiers. I am confident that the system will work fine because I have used a similar setup before. The [More]
Hello, I have VBA code that copies new Calendar entries to a secondary calendar. For recurring meetings it only copies the 1st meeting to the secondary calendar. Is there an Outlook VBA event that occurs whenever a Recurring appointment is created an [More]
I use Acrobat 11 Pro (Nl). The document background colour is yellow. I can create a white bleed. How can I get the bleed  in the same colour as the document? - thank youThere are no tools to extend background if it wasn't made big enough for bleed. T [More]
hi 2 all how to make my program forcefully error out even i have to get data regards sivaHi Mate, Just remove the quries which you execute Thanks Kash www.mkashu.blogspot.comRead other 3 answers [More]
Hi all, Please guid me how to change the ALV grid output of a report to ALV Tree Hirarchical display.Requirement is to change the output from ALV Grid to Tree Hirarchy. Thanks in advance. PavanHi, Hope this sample code will help: *& Report  Z_50657_A [More]
i bought the 2.0 Ghz processor macbook with 2 gigs of ram obviously, but i want 4 on it, is there a 3rd party (i believe thats what its called) company or webpage where i can buy "cheap" (by that i mean not so expensive, but not bad quality) ram [More]
Since I updated my MacBook Pro (Mid 2007) with the latest update 10.5.6 I've been having panic attacks. I first thought that it had something to do with what was plugged into the USB ports (Logitech USB mouse with LCC and Pinnacle HD Stick 800e). I r [More]
How SAO can help to increse its ROI(Returns on Investment) for a manufacturing industry? Edited by: RAJEEV SHARMA on Jan 28, 2009 5:39 AMHi A MANUFACTURING IMPERATIVE: ENTERPRISE SERVICE-ORIENTED ARCHITECTURE https://www.sdn.sap.com/irj/scn/go/portal [More]