Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
Sum({$<Year={$(=max(Year)-1)}>}[LineTotal])/Sum(TOTAL <DateID.Month> {$<Year={$(=max(Year)-1)}>}[LineTotal])
May be this
Sum({$<Year={$(=max(Year)-1)}>}[LineTotal])/Sum(TOTAL <DateID.Month> {$<Year={$(=max(Year)-1)}>}[LineTotal])
You are a legend. Thank you so much. It worked perfectly.