Daily Average based on cumulative sales line chart

[#1]

I am need to recreate a chart I have in Excel that is based on the daily averages per quarter.

On work day 1 we did $100 in sales so daily average is $100, on work day 2, we did another $50 in sales so now we hve $150 divided by two so daily avg is $75 (150/2), etc... the line chart should show $100 Day 1 $75 day two and so onh. How do I do this in the expressions. I currently have a full accumlation by day by quarter to show Year over Year and Quarter of Quarter but I wnat to change this to the daiy average line chart.

[#2]

Hi there,

yes, with the help from John Witherspoon I managed to get it done, please have a look at this post:

http://community.qlik.com/forums/p/24315/92933.aspx#92933

Lukas

[christian77]

Eureka!!! try now with a pivot table. There is not row number when you expand only an item. Add a couple of columns on the right, and see their behaviour.

Dimensionality()& ' - ' & noofrows(Total) & ' - ' & rowno(Total)

Dimensionality()& ' - ' & noofrows() & ' - ' & rowno()

Thanks.