I'm still not sure about how to show weighted price (each name or monthly average/weighted of weighted)
Anyways, tried to separate group by name x month.
Could you explain how you want to show weighted price?
In the end I'm interested in getting the weighted price for the three terciles?
Product Terciles-2_SM_10.2.twbx 34.2 KB
thanks for the elegant grouping, that works fine. The weighted price might need now an LOD on this level, but i don't get that working. Let me try to explain what i'm after:
for each tertile i'm interested in the weighted price in each month so i could plot a viz with those three lines displayed over time. As all products start at 100 each weighted tertile would also start at 100. For the second month the weighted price would be the sum of the prices of the three products in tertile one multiplied by their weight in that month divided by the sum of the three weights. Is there a way to get the different levels of aggregation to work?
thanks for your help :-)