Percentage in Dimension

[#1]

Hello,

Using this expression i get this table:

sum(SALES)/ sum(total(SALES))

Date	Actual 2016	Prev Year	Target 2016
Distribution	SALES	SALES	SALES
A	30,3%	10,9%	7,7%
B	-0,9%	15,7%	22,0%
C	3,2%	4,1%	6,9%
100,0%

What i need is to separate the percentage by dimensión DATE

Date	Actual 2016	Prev Year	Target 2016
Distribution	SALES	SALES	SALES
A	30,0%	20,0%	13,0%
B	20,0%	20,0%	10,0%
C	50,0%	60,0%	77,0%
total	100,0%	100,0%	100,0%

Could you help me please?

Thanks

[alexandros17]

Could you send an example

[saurabh5]

hi Belen,

I am little confused with your requirement is your ask to change the label of distribution dimension to date?

[#4]

In the first chart the sum of the percentages is 100%.

What i need is the weights in the dimensión "date": in each column.  Is this posible?

I do not know if i explain myself well......

[#5]

Date	Actual 2016	Prev Year	Target 2016
Distribution	SALES	SALES	SALES
A	10	18	32
B	20	15	40
C	5	3	10
what i have
Date	Actual 2016	Prev Year	Target 2016
Distribution	SALES	SALES	SALES
A	7%	12%	21%
B	13%	10%	26%
C	3%	2%	7%
TOTAL	23%	24%	54%	100%
what i NEED
Date	Actual 2016	Prev Year	Target 2016
Distribution	SALES	SALES	SALES
A	29%	50%	39%
B	57%	42%	49%
C	14%	8%	12%
TOTAL	100%	100%	100%	300%

[alexandros17]

Try with this expression:

Sum(Sales)/Sum(Aggr(Sales, Distribution,Date))

let me know

[ChiragPradhan · Accepted solution]

Hi Belen,

Use this expression Sum(Sales)/Sum(TOTAL<Company> Sales).

Regards

Chirag.

[#8]

Thanks