How do I show Percentage Revenue By Dimension (eg Year,Product) in a Block Chart

[siz_mahleka]

Hi

I would like to show a percentage of revenue breakdown by Year, Product in a Block Chart. As you can see in the example below, product B should be reflecting more towards 50% for the year 2009. The red, green and blue blocks should add upto 100% for each year. The expression formula I've used is

sum

(Revenue)/sum(TOTAL Revenue)

I can understand why this would not work because I'm using a sum of TOTAL revenue as opposed to the sum of total revenue by year. How can I have achieve something like sum(Revenue)/sum(TOTAL Revenue{By Year})

[sparur]

Hello.

try like this:

sum(Revenue)/sum(TOTAL <Year> Revenue)

[siz_mahleka]

Hi Sparur,

Thank you for such a quick reply. That has worked perfectly!

You are a star!

Regards,

Siz