Average value in stock - aggr?

[qlikeers]

Hi!

I have stuck to, what seems to be, a simple thing.

I have a table with fields:
- Day (YYYY-MM-DD),
- Month (YYYY-MM),
- ProductID,
- ProductType (two values, 1 or 2),
- Value in stock (for the day).

I have created Pivot Table with:

• Dimensions
  • Row
    • Month
    • ProductType

Now I need to create a measure that will show the average value in stock by month and product type (as in PT dimensions). I try with AGGR, but it does not work in any way.

How to do it?

[BrunPierre]

What sample data do you have and what result do you expect?

[agigliotti]

Hi @qlikeers ,

Why not using simple Avg(Value in stock) ?