100% Bar chart with 2 dimensions and one measure

[Anonymous]

Hi All,

Is it possible to create a 100% stacked bar with 2 dimensions and 1 measure

I have a bar chart with some sales value for 2 years.

Required: Create alternate measure to fit in fig 1 to show 100% split between products (as shown in Fig 3)

What I am getting is Fig 2 split between years as alternate measure.

I can create 4 measures to get total to 100% but its not ideal as I will be duplicating 10 graphs for # and %.

Fig 1 measure: Sum(Sales)

Fig 2:  Sum(Sales) /sum(total <Year> Sales)

Fig 3:

Currently creating 4 measure for each product:

num(sum({$<Product={'P1'} >} Sales)

/sum({<Product= {'P1','P2','P3','P4'}>}Sales),'#,##0%')

Is there any way I can create a one measure to get these split for products to be 100% with 2 dimensions.

[sunny_talwar]

What is your first dimension? Is it Year or something else?

[Anonymous]

First Dimension: Year

Second Dimension: Product

[sunny_talwar]

Is year a calculated or derived field by any chance?

[Anonymous]

I have edited the Auto calendar to derive a YearAgo field for Total year & last Year 

if(12*Year(Today())+Month(Today())-12*Year($1)-Month($1) >=1 and 12*Year(Today())+Month(Today())-12*Year($1)-Month($1) <= 12, 'Total Year',

if(12*Year(Today())+Month(Today())-12*Year($1)-Month($1) >=13 and 12*Year(Today())+Month(Today())-12*Year($1)-Month($1) <= 24,'Last Year',null())) as YearAgo,