Set analysis(Lost Amount)

[mario-sarkis]

Lost Amount:

i have a data looks like that

ID     Jun-2014    May-2014  April-2014 .......

Each ID has an ammount in each month-year

i need to show the evolution in a line chart of lost amount for each month

Example

ID     Jun-2014    May-2014  April-2014 .......

x       1000           2000           1500

Evolution in a pie chart is

ID     Jun-2014    May-2014               April-2014 .......

x       1000           (2000-1000)           1500-(2000-1000)

Please help Than you

[jonathandienst]

I think this will do it for you:

=Sum(x) - Above(Sum(x))

or

=Sum(x) - Above(Total Sum(x))

[sunilkumarqv]

try like attached