+ Reply to Thread
Results 1 to 2 of 2

Pivot Table; possible ways to correlate uniform alignment or meeting of certain criteria

  1. #1
    Registered User
    Join Date
    07-28-2013
    Location
    Eastern Seaboard, North America
    MS-Off Ver
    Excel 2010
    Posts
    36

    Pivot Table; possible ways to correlate uniform alignment or meeting of certain criteria

    As an example, contemplate that one had a Pivot Table to attempt to record various words and their meanings across multiple languages. So, for example, the word for yes in various languages. "Oui" in French and "Si" in both Italian and Spanish. One wanted to assess which languages had the same word for "Yes" as well as the same word for various other concepts, that the language shared the same word with another language. So, for example, "toro" means bull in both Spanish and Italian, while Ventura means "good fortune" in both Spanish and Italian. How could I set up a Pivot Table that would return all other languages where "Si" means yes, toro means bull and Ventura means "good fortune"?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,570

    Re: Pivot Table; possible ways to correlate uniform alignment or meeting of certain criter

    I do not think it is possible just within pivot table. You have to do this assignment on data preparation stage. so you have to add "translated word" column to your dataset and either using one of the languages in question or some other - may be Esperanto http://en.wikipedia.org/wiki/Esperanto build the "universal meaning" which can be counted then in a standard way with Pivot Table.
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find first table entry meeting several criteria
    By glenn37475474 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-06-2015, 04:21 AM
  2. [SOLVED] Pivot Table Column Alignment
    By NBVC in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 10-16-2014, 03:52 AM
  3. [SOLVED] Pivot table column alignment
    By Runnin L8 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-16-2013, 08:50 PM
  4. PIVOT table formatting not uniform?
    By Coeus in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-18-2013, 07:13 AM
  5. Potential ways to format binary data with a pivot table.
    By Ali2013 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-17-2013, 09:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1