Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Theo_Westseit
Contributor III
Contributor III

Add column in pivot table / Average

Hello Guys,

i have a pivot table with the following three information:

Name (Dimension)
Month (Column)
Numbers (Values)

    Month    
  Jan Feb Mar ...
Name 1  Number 1  Number 2 Number 3 ...

 

Now i want to add a single column after the last month (December) and calculate/display the Average value from Number 1-12.

 

    Month     Average
  Jan Feb Mar ...  
Name 1  2 1 1,5 ... 1,5

 

How do i add the single column on the right side an how to calculate the Average value?

Thanks in advance!!

Labels (2)
4 Replies
jmartineze
Partner - Creator
Partner - Creator

hi,

i think the best and easy solution is use a straight with one measure for each month and add average measure. Also you can give a displey condition if you need.

Theo_Westseit
Contributor III
Contributor III
Author

Thanks for your reply.

Unfortunately, im using more dimensions and need to stick with the pivot table...
Do you see a possibility to do this with a pivot table?

jmartineze
Partner - Creator
Partner - Creator

First off all is not posible. But you can do something in the script that allows your goal.

Maybe you can calculate average for name1 in the script and rename average as month. Or generate the complete table in the script and show it. 

Theo_Westseit
Contributor III
Contributor III
Author

Thats a good idea! Thanks.