sales average in pivot

[paolojolly]

Hi, I'm pretty new to Qlikview and I need help to create a pivot chat with sales data

I have a document in which I can select a date.

A pivot chart for each year for the period from beginning of the year to selected date extract sales data.

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 sales average

Can someone help me?

Thank you very much

[swuehl · Accepted solution]

Maybe like attached?

I used InYearToDate() function to filter the fact data within the expression.

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.

[paolojolly]

Thanks, this is what I need