topic In Pivot table, values are missing while dividing each cell value with totals in App Development https://community.qlik.com/t5/App-Development/In-Pivot-table-values-are-missing-while-dividing-each-cell-value/m-p/1795965#M62427 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="divyajayan_1-1617187458537.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52162iC9E8DC58508DC710/image-size/medium?v=v2&amp;px=400" role="button" title="divyajayan_1-1617187458537.png" alt="divyajayan_1-1617187458537.png" /></span></P><P>My requirement here is to divide each cell value with the totals. That means in Backlog target, it should give 707/871 which is 0.81. Similarly I need the values in rest of cell like 5/871, 12/871, 7/871, 23/871 goes on.. However I am getting values in certain cells only not all. Not sure what I am missing here. The formula I am using is&nbsp;(aggr(Count(UNIQUE_ID),MONTH_DUE,DELIVERED_BY)/aggr(Count(UNIQUE_ID),MONTH_DUE))</P><P>Can someone help me to figure out the issue?</P> Mon, 20 Dec 2021 21:02:46 GMT divyajayan 2021-12-20T21:02:46Z In Pivot table, values are missing while dividing each cell value with totals https://community.qlik.com/t5/App-Development/In-Pivot-table-values-are-missing-while-dividing-each-cell-value/m-p/1795965#M62427 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="divyajayan_1-1617187458537.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52162iC9E8DC58508DC710/image-size/medium?v=v2&amp;px=400" role="button" title="divyajayan_1-1617187458537.png" alt="divyajayan_1-1617187458537.png" /></span></P><P>My requirement here is to divide each cell value with the totals. That means in Backlog target, it should give 707/871 which is 0.81. Similarly I need the values in rest of cell like 5/871, 12/871, 7/871, 23/871 goes on.. However I am getting values in certain cells only not all. Not sure what I am missing here. The formula I am using is&nbsp;(aggr(Count(UNIQUE_ID),MONTH_DUE,DELIVERED_BY)/aggr(Count(UNIQUE_ID),MONTH_DUE))</P><P>Can someone help me to figure out the issue?</P> Mon, 20 Dec 2021 21:02:46 GMT https://community.qlik.com/t5/App-Development/In-Pivot-table-values-are-missing-while-dividing-each-cell-value/m-p/1795965#M62427 divyajayan 2021-12-20T21:02:46Z