How to duplicate januar value for all month of year?

[tequila]

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.



 

[pricter]

Have you tried to use tuple function ?
For example tuple ( [Product] , [Measure] , [Jan])