Total function in chart

[#1]

Hello to all,

I'm having some issues on the creation of a chart with the % of expenses for my 3 years database.

I have the following kinds of expenses:

Administration;

Computer;

Distribution;

Production;

Selling;

Technical.

I wish to build a line chart in which each line stands for each kind of expense, as the % of the total.

I made a brief, in a child way, to demonstrate the chart I need.

In my Dashboard, the Year field is always selected, so, it's something to take into consideration that makes it harder to set a good set analysis.

Thanks a lot guys!!!!!!

[sunny_talwar]

May be this:

Sum({<Year, Expenses = {'Administration'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Computer'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Distribution'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Production'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Selling'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Technical'}>}Expenses)/Sum({<Year>}Expenses)

[#3]

Sunny T,

It worked very well.

Thanks a lot!!!!

[sunny_talwar]

Great