Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
RTF37303832343a204865616469
RTF37303832343a204865616469
Active Members

Active Members View
Image RemovedActive Members ViewImage Added
The Active Members view lists all active members based on the Member Type and Dues Paid Thru fields on the Companys record.

Anchor
RTF32363638303a204865616469
RTF32363638303a204865616469
Active Members Near Expiration

Active -Members Near Expiration View
Image RemovedActive Members Near Expiration ViewImage Added
The Active Members Near Expiration view displays the member companies whose membership will expire within the next 90 days (based on the company's Dues Paid Thru date). This is a hierarchal view that also displays a company's associated Persons and Subscriptions.

Company Hierarchy

Company Hierarchy View
Image RemovedCompany Hierarchy ViewImage Added
The Company Hierarchy view lists companies and each company's subsidiaries in a hierarchical view.

Anchor
RTF34383533353a204865616469
RTF34383533353a204865616469
Company Lookup

Company Lookup View
Image RemovedCompany Lookup ViewImage Added
The Company Lookup view is a prompted view to locate Companies based on Name. When prompted, start to enter the name of the Company (the full name is not necessary) and click OK to load the view.

Anchor
RTF35333531383a204865616469
RTF35333531383a204865616469
Companies Modified Last 24 Hours

Companies Modified Last 24 Hours View
Image RemovedCompanies Modified Last 24 Hours ViewImage Added
The Companies Modified Last 24 Hours view displays all Companies records that were recently modified (within the last 24 hours).

Anchor
RTF32393031373a204865616469
RTF32393031373a204865616469
Companies w/Orders Last 12 Months

Companies w/Orders View
Image RemovedImage Added
The Companies w/Orders Last 12 Months view lists all companies who placed orders within the last 12 months.

Anchor
RTF36373932383a204865616469
RTF36373932383a204865616469
Prior Customer, Not In Last 12 Months

Prior Customer, Not In Last 12 Months View
Image RemovedPrior Customer, Not In Last 12 Months ViewImage Added
The Prior Customer, Not In Last 12 Months view lists all companies that have placed orders in the past but not within the last 12 months.

...

Anchor
RTF33353736313a204865616469
RTF33353736313a204865616469
Average Revenue/Member By Country

Average Revenue/Member By Country View
Image RemovedImage Added
The Average Revenue/Member By Country chart view is a bar chart of a sub-set of countries and the average revenue for companies in those countries. When you select an item in the chart the By Revenue Category (Page 127) pivot table loads.

Anchor
RTF36393934353a204865616469
RTF36393934353a204865616469
Avg. Rev. Per Member By Country (Drill Down)

Avg. Rev. Per Member By Country (Drill Down) View
Image RemovedAvg. Rev. Per Member By Country (Drill Down) ViewImage Added
The Average Revenue Per Member By Country (Drill Down) column chart view displays the average company revenue by country. Clicking a column in this view opens the By Rev. Category/Co. Type (Page 128) pivot table for the selected Country's companies.

Anchor
RTF31383435333a204865616469
RTF31383435333a204865616469
Avg. Rev. Per Member By Country (Western Europe)

Avg. Rev. Per Member By Country (Wester Europe) View
Image RemovedAvg. Rev. Per Member By Country (Wester Europe) ViewImage Added
The Average Revenue Per Member By Country column chart is a graphical representation of the average company revenue by only Western European Countries. Clicking a column in this view opens the By Rev. Category/Co. Type (Page 128) pivot table for a country's Companies.

Anchor
RTF36353833363a204865616469
RTF36353833363a204865616469
By Join Year/Member Type

By Join Year/Member Type VIew
Image RemovedImage Added
The By Join Year/Member Type line chart is a graphical representation that displays members grouped by their respective join year.

Anchor
RTF31343939353a204865616469
RTF31343939353a204865616469
By Member Type

By Member Type View
Image RemovedImage Added
The Count By Member Type chart view is a 3-D pie chart that groups companies by member type.

Anchor
RTF37363139363a204865616469
RTF37363139363a204865616469
By Revenue Category/Company Type

By Revenue Category/Company Type View
Image RemovedImage Added
The By Revenue Category/Company Type view is a Doughnut chart that displays the number of companies by company type and revenue category.

Anchor
RTF31373034353a204865616469
RTF31373034353a204865616469
Count By Company Type (Pie Chart)

Count By Company Type View
Image RemovedCount By Company Type ViewImage Added
The Count By Company Type chart view is a 3-D pie chart of companies grouped by company type. Clicking one of the areas within the chart opens the Avg. Rev. Per Member By Country (Drill Down) (Page 119) column chart for the selected company type.

Anchor
RTF38363630353a204865616469
RTF38363630353a204865616469
Members By Country (Pie Chart)

Members By Country View
Image RemovedMembers By Country ViewImage Added
The Members By Country chart view is a Pie Chart that shows a breakdown of member companies (Member Type of Corporate Member) broken down by their country.

Anchor
RTF37343332383a204865616469
RTF37343332383a204865616469
Members By Country/State

Members By Country/State View
Image RemovedImage Added
The Members By Country/State chart view is a stacked bar graph of corporate members broken down by Country and then State.

Anchor
RTF35333330383a204865616469
RTF35333330383a204865616469
New Members By Qtr/Year

New Members By Qtr/Year View
Image RemovedImage Added
The New Members By Qtr/Year column chart displays the number of new corporate members who joined the organization by quarter and year.

Anchor
_pivot
_pivot
Pivot Table Views

The following sample Pivot Tables are contained within the Companies service:

  • By Revenue Category 
  • By Rev. Category/Co. Type 
  • Companies w/Active Committee Participation 
  • Top 10 Customers - Last 12 Months 
  • Top 10 Customers Overall 

...

Anchor
_pivot1
_pivot1
By Revenue Category

...

Image RemovedBy Revenue Category ViewImage Added
The By Revenue Category pivot table displays companies grouped by revenue, revenue category, and Company Type.

...

Anchor
_pivot2
_pivot2
By Rev.

...

Category/Co. Type

...

Image RemovedImage Added
The By Revenue Category/Co. Type pivot table groups companies by company type and revenue category (revenue category is sorted in descending order).

Anchor
RTF33373131383a204865616469
RTF33373131383a204865616469
Companies w/Active Committee Participation

Companies w/Active Committee Participation View
Image RemovedImage Added
The Companies w/Active Committee Participation pivot table lists companies that are linked to a person who is a member of a committee term with active committee participation.

Anchor
RTF37393539343a204865616469
RTF37393539343a204865616469
Top 10 Customers By Revenue, Last 12 Months

Top 10 Customers By Revenue, Last 12 Months View
Image RemovedTop 10 Customers By Revenue, Last 12 Months ViewImage Added
The Top 10 Customers - Last 12 Months pivot tables shows the top 10 customers in terms of sales for the last 12 months.

Anchor
RTF31363033373a204865616469
RTF31363033373a204865616469
Top 10 Customers By Revenue Overall

Top 10 -Customers By Revenue Overall View
Image RemovedTop 10 Customers By Revenue Overall ViewImage Added
The Top 10 Customers Overall pivot table shows the top ten customers in terms of sales over the history of the system to date.

Anchor
_cal
_cal
Calendar View

The following Calendar view is found within the Companies service:

...

Calendar of Member Expirations

Calendar of Member Expirations View
Image RemovedCalendar of Member Expirations ViewImage Added
The Calendar of Member Expirations is a calendar view that shows all upcoming member expirations based on the member's Dues Paid Through date.