Jump to content
  • 0

Likert Scale in Pivot Table using Lookup Fields

Go to solution Solved by skcombs,


In a survey, I am using a Likert Scale of 4 values (Strongly Disagree -> Strongly Agree) to answer several questions on a submission form.  I would like to create a Pivot Table with questions on one dimension,  scale names on the other, with a count of User-Ids as the values.  How do I use the scale values (Strongly Agree...) from a lookup table to specify the rows (or columns) ?   ALSO, I kept getting an ERROR when I submitted this question telling me to try again, so Sorry for the multiple submissions.

Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hello @skcombs,

Could you confirm, please, that you want to create the Pivot Table with the following view?


If so, then I am afraid this is not possible to create a Pivot Table using the lookup table as a data source.

It is possible only with a table that has specific table design.

Do you have the table with the similar design at the moment?



Link to post
Share on other sites
  • 0

I have a table where the responses are stored as numbers.  A lookup table has the pairing of labels to numbers, and the labels are used for the radio button responses.  One reason for this is that I want to compare the rating a respondent gives to each question over time to the same question.

Link to post
Share on other sites
  • 0

Hello @skcombs,

I will describe the solution based on the assumption that you have the table design like this.

1) This is the Lookup table that stores  possible options:


2) This is the table with responses:



3) It is possible to create the Pivot as on the screenshot in my previous post on the base of the table that has the following table design:


4) You may fill in the table for Pivot Table with values by Task/Triggered Action.

Here is the part of Task example: 


Task is helpful for the existing records. You may use the similar Triggered Action for new (inserted) records, the only difference is that in the Trigger you should SELECT FROM #inserted instead of the Responses table from the example.

Hope this helps. 

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...