percentage stacked bar chart help

[Anonymous]

I want to make a percentage stacked bar chart with sales data per territory per month but only for the last year. The last year of data was in 2014. This is where I am currently at.

The expression I used in the measure was:

Sum({$<Year={$(=max(Year)-1)}>}[LineTotal])

Line total is the order total for a sale.

I need the current component contributed by each region to be expressed as a percentage of its total stack, with the restriction of data only from the most recent year of sales.

[sunny_talwar · Accepted solution]

May be this

Sum({$<Year={$(=max(Year)-1)}>}[LineTotal])/Sum(TOTAL <DateID.Month> {$<Year={$(=max(Year)-1)}>}[LineTotal])

[Anonymous]

You are a legend. Thank you so much. It worked perfectly.