Seperate total Values

[#1]

Hi All,

I'm currently having problems seperating total values on my pivot chart.

Month	Segment	Amt
Oct		20788814.93
Oct	A	20788814.93
Oct	B	20788814.93
Oct	C	20788814.93
Oct	D	20788814.93
Oct	E	20788814.93
Oct	F	20788814.93
Oct	-	20788814.93

Month	Segment	Amt
Nov		19838230.06
Nov	A	19838230.06
Nov	B	19838230.06
Nov	C	19838230.06
Nov	D	19838230.06
Nov	E	19838230.06
Nov	F	19838230.06
Nov	-	19838230.06

Now, When I select both MONTH.

Month	Segment	Amt
Oct		40627044.99
Oct	A	40627044.99
Oct	B	40627044.99
Oct	C	40627044.99
Oct	D	40627044.99
Oct	E	40627044.99
Oct	F	40627044.99
Oct	-	40627044.99
Nov		40627044.99
Nov	A	40627044.99
Nov	B	40627044.99
Nov	C	40627044.99
Nov	D	40627044.99
Nov	E	40627044.99
Nov	F	40627044.99
Nov	-	40627044.99

It totals up Oct & Nov. IS there any way I can seperate the values?

I am using the total in the expression

Thanks

[kaushiknsolanki]

HI,

     Try your expression for Amt as below.

     Sum(total <Month> Amt)

Regards,

Kaushik Solanki