topic Re: sales average in pivot in QlikView https://community.qlik.com/t5/QlikView/sales-average-in-pivot/m-p/1030350#M928855 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>I used InYearToDate() function to filter the fact data within the expression.</P><P></P><P>I do get slightly different results than shown in your chart, because I calculate the respective year to date aggregates, not year to end of selected month.</P></BODY></HTML> Sun, 20 Mar 2016 00:02:24 GMT swuehl 2016-03-20T00:02:24Z sales average in pivot https://community.qlik.com/t5/QlikView/sales-average-in-pivot/m-p/1030349#M928854 <HTML><HEAD></HEAD><BODY><P>Hi, I'm pretty new to Qlikview and I need help to create a pivot chat with sales data</P><P>I have a document in which I can select a date.</P><P>A pivot chart for each year for the period from beginning of the year to <SPAN style="font-size: 13.3333px;">selected </SPAN>date extract sales data. </P><P><IMG alt="Immagine.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118663_Immagine.png" style="height: auto;" /></P><P>I ask help to see if the formula that I use as dimension in the chart is the most correct and ask help for display a horizontal reference line with the <SPAN style="font-size: 13.3333px;">sales </SPAN>average</P><P></P><P>Can someone help me?</P><P>Thank you very much</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/sales-average-in-pivot/m-p/1030349#M928854 paolojolly 2020-11-25T16:16:04Z Re: sales average in pivot https://community.qlik.com/t5/QlikView/sales-average-in-pivot/m-p/1030350#M928855 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>I used InYearToDate() function to filter the fact data within the expression.</P><P></P><P>I do get slightly different results than shown in your chart, because I calculate the respective year to date aggregates, not year to end of selected month.</P></BODY></HTML> Sun, 20 Mar 2016 00:02:24 GMT https://community.qlik.com/t5/QlikView/sales-average-in-pivot/m-p/1030350#M928855 swuehl 2016-03-20T00:02:24Z Re: sales average in pivot https://community.qlik.com/t5/QlikView/sales-average-in-pivot/m-p/1030351#M928856 <HTML><HEAD></HEAD><BODY><P>Thanks, this is what I need</P></BODY></HTML> Sun, 20 Mar 2016 22:10:39 GMT https://community.qlik.com/t5/QlikView/sales-average-in-pivot/m-p/1030351#M928856 paolojolly 2016-03-20T22:10:39Z