% cell of expression total of a row

[#1]

Hi guys,

My title is not the not very clear, I know, but I did not know how to put it into words.

What I have got so far is a simple Pivot Table with

*dimension ARTICLE (ART1, ART2, ART3)

*dimension MONTH (JAN, FEB, MARCH)

*expression: sum({$<Month={"<= $(=num(Month))"}>} Sales) + sum({$<Month={"<= $(=num(Month))"}>} Returns)

In Excel this looks like:

ARTICLE	JAN	FEB	MARCH
ART1	5	6	2
ART2	1	3	4
AER3	1	1	2

What I need is the following:

I need to show the contribution of each month to the total sales of an article (so basically the % of the row total).

ARTICLE	JAN	%	FEB	%	MARCH	%	TOTAL
ART1	5	38%	6	46%	2	15%	13
ART2	1	13%	3	38%	4	50%	8
AER3	1	25%	1	25%	2	50%	4

Every year I will select the current month and it should show the months before that one plus the month itself (see expression) AND the percentage of those months.

Can anyone help me out please?

Thanks a lot!

[MK_QSL]

Try

sum({$<Month={"<= $(=num(Month))"}>} Sales) + sum({$<Month={"<= $(=num(Month))"}>} Returns)/

(sum(TOTAL <ARTICLE>{$<Month={"<= $(=num(Month))"}>} Sales) + sum(TOTAL <ARTICLE>{$<Month={"<= $(=num(Month))"}>} Returns))

Update: Missed () ...

Thanks Jagan

[jagan · Accepted solution]

Hi,

Divide the same expression with TOTAL option

=(sum({$<Month={"<= $(=num(Month))"}>} Sales) + sum({$<Month={"<= $(=num(Month))"}>} Returns)) /

(sum(TOTAL <ARTICLE>{$<Month={"<= $(=num(Month))"}>} Sales) + sum(TOTAL <ARTICLE>{$<Month={"<= $(=num(Month))"}>} Returns))

Regards,

Jagan.

[#4]

That's the one! Thanks a bunch !!