topic Add a calculated element to PIVOT? in QlikView https://community.qlik.com/t5/QlikView/Add-a-calculated-element-to-PIVOT/m-p/667337#M1073684 <HTML><HEAD></HEAD><BODY><P>Add a calculated element to PIVOT? I have Forecast Category for my rows and Commit Week for my Columns with deal dollars as data and currently have the following Forecast Categories:&nbsp; Commit, Pipeline, Upside, and Won; and would like to add into the Pivot table the calculated field of Forecast which equals Commit $$s&nbsp;&nbsp; Won $$s. Is this possible to do, I’m new to QlikView but have some experience with SQL? Thanks you for your help Rich</P><P></P><P><IMG alt="PIVOT.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/63277_PIVOT.jpg" /></P></BODY></HTML> Mon, 28 Jul 2014 16:26:04 GMT 2014-07-28T16:26:04Z Add a calculated element to PIVOT? https://community.qlik.com/t5/QlikView/Add-a-calculated-element-to-PIVOT/m-p/667337#M1073684 <HTML><HEAD></HEAD><BODY><P>Add a calculated element to PIVOT? I have Forecast Category for my rows and Commit Week for my Columns with deal dollars as data and currently have the following Forecast Categories:&nbsp; Commit, Pipeline, Upside, and Won; and would like to add into the Pivot table the calculated field of Forecast which equals Commit $$s&nbsp;&nbsp; Won $$s. Is this possible to do, I’m new to QlikView but have some experience with SQL? Thanks you for your help Rich</P><P></P><P><IMG alt="PIVOT.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/63277_PIVOT.jpg" /></P></BODY></HTML> Mon, 28 Jul 2014 16:26:04 GMT https://community.qlik.com/t5/QlikView/Add-a-calculated-element-to-PIVOT/m-p/667337#M1073684 2014-07-28T16:26:04Z