Pie Charts from Multiple Columns

[#1]

Hi all,

I have 10 columns which have an 'hours' figure in them (as in hours of audio)

I'd like to create a pie chart that shows the sum of all the rows in each column as a percentage but i'm struggling to achieve this! I have added all 10 columns as dimensions, but what should my expression be??

[jagan]

Hi,

Can you attach the sample data file.  It helps in understanding the problem.  The max limit of Dimensions in only 3.

After that the expressions are ignored.  The dimensions are also limited based on the graph you choose.

Regards,

Jagan.

[#3]

Thanks for the reply, sadly i can't really post the data file but it is a table of:

Year (Derived from Date on Reload), Date (yyyy-mm-dd), Hours1, Hours2, Hours3, Hours4, Hours5, Hours6, Hours7, Hours8, Hours9, Hours10

Ideally i want a pie chart saying for a year Hours1 was 20%, Hours2 was 10%, Hours3 was 5% etc.