any one can help i want to display table like this

[#1]

name  month  amount

a         aug      500

a         sep      500

a         oct       500

a         nov       500

-------------------------------

total                2000

i want to display table like this

name  month  amount

a         aug      2000

a         sep      1500

a         oct       1000

a         nov       500

-------------------------------

total                0

[qliksus]

Hi,

try this

sum

(total amount)- rangesum(above(sum(amount),1,rowno()))

[SunilChauhan]

see the attached file

[#4]

For one employee its ok

but i want show as below

My sourse  is below
Name	Month	Amount
X	Aug	500
X	Sep	500
X	Oct	500
X	Nov	500
X	Dec	0
XX	Aug	500
XX	Sep	400
XX	Oct	300
XX	Nov	300
XX	Dec	0
I want to show
Month	X	XX
Aug	2000	1500
Sep	1500	1000
Oct	1000	600
Nov	500	300
Dec	0	0

Regards

Sankar

[kaushiknsolanki]

HI,

    Create a pivot chart with dimensions as Month, Name and expression as Sum(values)

    Now you can drag the Name field as take it to the above of the expression.

    Hope this helps.

Regards,

Kaushik Solanki