I have a table with products and every product can have more shipping dates. Like this:
PoductID ShippingDate
1234 12.10.2012
1234 13.09.2012
1234 15.08.2012
4567 01.01.2012
4567 22.04.2012
4567 05.09.2012
I need to show now all products in a chart they where shipped in a certain time. for example 04.09.2012 - 16.10.2012. but the avg date should be in this daterange. so 1234 needs to be shown cause the avg(date) is in the daterange and 4567 shouldnt be shown but is because of the date 05.09.2012, cause right now my set analysis look like this
only({<ShippingDate = {'...'}>}ProductID)
i tried already:
only({<avg(ShippingDate) = {'...'}>}ProductID)
but this is not working
can i use avg() like this?? or does anyone know a workaround???
i appriciate any kind of help you guys can give me.
I want to see the productID as dimension and as expression i want my profit!! maybe i have to explain the problem a lil more specific!!
I have a slidecontrol where I can choose how many week my product can be old (1-10). the slidecontrol is base on 2 variables. so when i choose 5 on the slide control I want to see all products with the average age of 5 weeks. (age is based on the avg shipping date but to explain all that in detail will get to complicated) so what i actually need is an dynamic dimension in a pivot table.
