topic Re: Total in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Total-in-a-pivot-table/m-p/1260397#M397637 <HTML><HEAD></HEAD><BODY><P>The Aggr function did the job in the meantime.</P></BODY></HTML> Tue, 17 Jan 2017 13:00:34 GMT puttemans 2017-01-17T13:00:34Z Total in a pivot table https://community.qlik.com/t5/QlikView/Total-in-a-pivot-table/m-p/1260396#M397636 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>I'm a bit puzzled on how to insert extra information into a pivot table in 2 extra columns. The 'surocc' and 'relevés' would need to be integrated in a column in the pivot table. </P><P></P><P>1)Surocc shows the total number of dates a value of 100 or more has been recorded for a given train (surocc)</P><P>2) count the total number of dates/days there is a measure for each train.(relevés)</P><P></P><P>Selection of the period may vary, so I cannot pre-calculate it. I don't see how it's done, and all my efforts so far lead to an 'error' in the pivot. Can anyone please share a solution?</P><P></P><P>Kind regards,</P><P></P><P>Johan</P></BODY></HTML> Tue, 17 Jan 2017 09:05:45 GMT https://community.qlik.com/t5/QlikView/Total-in-a-pivot-table/m-p/1260396#M397636 puttemans 2017-01-17T09:05:45Z Re: Total in a pivot table https://community.qlik.com/t5/QlikView/Total-in-a-pivot-table/m-p/1260397#M397637 <HTML><HEAD></HEAD><BODY><P>The Aggr function did the job in the meantime.</P></BODY></HTML> Tue, 17 Jan 2017 13:00:34 GMT https://community.qlik.com/t5/QlikView/Total-in-a-pivot-table/m-p/1260397#M397637 puttemans 2017-01-17T13:00:34Z