https://community.qlik.com/t5/App-Development/Percentages-in-two-columns-in-a-pivot-table/m-p/1689530#M52642 <P>I have a pivot table that's showing details of edits done to some data. The rows show the edit reason and there are two columns: one that looks at the last 7 days, and the other looks at earlier data.</P><P>When I simply want a count it all works fine, but what I'm after now is to add percentages. If I try this:</P><P>count(reasoncode)/count(Total(reasoncode))</P><P>it gives me a percentage for each cell based on the total number of edits irrespective of the date. (see below) What I need is a way to divide by the total edits within the timeframes specified by the columns.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Averages.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30995i364CF97971031878/image-size/large?v=v2&amp;px=999" role="button" title="Averages.PNG" alt="Averages.PNG" /></span></P><P>&nbsp;</P><P>cheers</P> Mon, 20 Dec 2021 21:32:42 GMT D_Williams 2021-12-20T21:32:42Z https://community.qlik.com/t5/App-Development/Percentages-in-two-columns-in-a-pivot-table/m-p/1689530#M52642 <P>I have a pivot table that's showing details of edits done to some data. The rows show the edit reason and there are two columns: one that looks at the last 7 days, and the other looks at earlier data.</P><P>When I simply want a count it all works fine, but what I'm after now is to add percentages. If I try this:</P><P>count(reasoncode)/count(Total(reasoncode))</P><P>it gives me a percentage for each cell based on the total number of edits irrespective of the date. (see below) What I need is a way to divide by the total edits within the timeframes specified by the columns.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Averages.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30995i364CF97971031878/image-size/large?v=v2&amp;px=999" role="button" title="Averages.PNG" alt="Averages.PNG" /></span></P><P>&nbsp;</P><P>cheers</P> Mon, 20 Dec 2021 21:32:42 GMT https://community.qlik.com/t5/App-Development/Percentages-in-two-columns-in-a-pivot-table/m-p/1689530#M52642 D_Williams 2021-12-20T21:32:42Z https://community.qlik.com/t5/App-Development/Percentages-in-two-columns-in-a-pivot-table/m-p/1689534#M52643 <P>Looks like Last7 and Earlier are defined as dimensions; try define them as measures (i.e. create two measure with set expression within them)</P> Tue, 31 Mar 2020 16:11:12 GMT https://community.qlik.com/t5/App-Development/Percentages-in-two-columns-in-a-pivot-table/m-p/1689534#M52643 lorenzoconforti 2020-03-31T16:11:12Z