Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Average column in pivot table or Table

I have a pivot table that shows expenses per month. How can I create a column that shows average expenses for the selected period?

EXAMPLE PIVOT TABLE

     

2016-Jan2016-Feb2016-MarTOTALSAVG
Payee 1 200,00 € 150,00 € 350,00 € 175,00 €
Payee 2 120,00 € 120,00 € 120,00 €
Payee 3 400,00 € 300,00 € 700,00 € 350,00 €

I tried with Aggr() function, but it not consider the months where the value is null



Some advice?

1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi

please refer to my example of dealing with totals (see link).. basicly instead of another total you can create a value for AVG and "voila". I have attached there a working files so you can look at the code

How to add a second total row in straight table?

hope this helps

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.