Any one can help me urgent please

[#1]

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

[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

[#3]

What's the logic on the sum? you're adding from dec backwards?

dec = 0

dec + nov = ?

dec + nov + oct and so on?

[SunilChauhan · Accepted solution]

see the attached file

hope this helps

[#5]

Dear Sunil

My sourse  is below
Name	Month	Amount
X	Aug	500
X	Sep	500
X	Oct	500
X	Nov	500
X	Dec	0
Total	2000
XX	Aug	500
XX	Sep	400
XX	Oct	300
XX	Nov	300
XX	Dec	0
Total	1500

the above source i want to show as below. is it posible  help me please

	Month
Name	Aug	Sep	Oct	Nov	Dec
X	2000	1500	1000	500	0
XX	1500	1000	600	300	0

Regards

Sankar

[richard_chilvers]

Hi

You can do this using a table in a Chart object.

Name will be your Dimension.

You will need an expression for each month of the year, which will be something like :

=SUM(IF(Month='Jan',Amount)

You might need to ignore the Total records if there are any in your source.

I hope this helps. Someone else may have a more elegant solution !

Regards

Richard