2 Replies Latest reply on Mar 7, 2012 11:53 PM by Daniel Thull

# How can I colour elements of a circle view based on percentage of total of each column?

Hi,

I'm trying to highlight how many brands make up 80% of sales in each country of our region. For each single country I was able to do a nicely coloured bar chart that plots sales for each brand and colours the bars based on the contribution to the country total sales (see below and attached workbook). I used this formula: running_sum(SUM([Sales])) / TOTAL(SUM([Sales])) across the table to colour.

In order to show the same information across multiple countries I would like to use a circle view by plotting countries as columns, sales as rows and a circle for each brand.

Unfortunately I haven't found out how I can colour the brand circles based on their contribution to *country* sales. Can anybody help?

Thanks,

Daniel

• ###### 1. Re: How can I colour elements of a circle view based on percentage of total of each column?

Hi Daniel,

Does using the % of country sales calculation (on the color shelf) work if you change place Brand on the level of detail shelf, then right click on the calculation and select Compute Using-->Brand?

-Tracy

1 of 1 people found this helpful
• ###### 2. Re: How can I colour elements of a circle view based on percentage of total of each column?

Hi Tracy,

although this doesn't do exactly what I was hoping for, it still might work for my purposes. Basically now each brand is colored by its contribution to the total country sales. Ideally I would have liked to color them based on the aggregate sum (Brand 1 20%, brand 2 15% (aggregate 35%), brand 3 10% (aggregate 45%) but if I choose the right color bands I can get the same effect (see below).

Thanks,

Daniel