Hello,
i have chart with 12 months (1,2,3...12) on x- axis and in series [Item1] (contain Product A + Product B + Product C).
Product A has only "opening value" in Januar, rest of months are '0'.
What i need is how can i have for Februar - Product A - "Januar value" + Product B - "Februar value" + Product C "Februar value" and so go on?
Also Product A Januar value (FIX) for all the year - and product B and Product C value month 1.2.3.4. etc.
I have try with:
Aggregate(currentmeasure within set set ([product A]) + [Product B] +[product C]))
or total(product A) + B + C
but the result is wrong.
i use a dimenional package.
can anyone help me?
thnx.
Have you tried to use tuple function ?
For example tuple ( [Product] , [Measure] , [Jan])