Stacked chart representation

[#1]

Hi,

I need to display a stacked chart.Below mentioned is the data.

Quarter	Region	Revenue-Type	Actual/Flash	Budget
Q1	AMS	A	123	140
Q1	AMS	B	345	350
Q1	AMS	C(A+B)	468	490
Q1	AMS	D	123	160

The chart should show only  C as sum of  (A+B) in the stacked order and D .

[sujeetsingh]

See this sample

[#3]

Hi Sujeet,

Thanks for your reply. Its helpful. But i need revenue type D to be shown in the same chart with out stacked representation.

And moreover the stacked representation is shown only for Actual/Flash i need it to be shown to budget in the same way..

[sujeetsingh]

You can try to implement it by using the expression group as i have made one in this sample

[#5]

Thanks sujeet.

[#6]

Hi Sujeet,

Looks like the numbers are wrong in the calculation.can you please check.

The stacked representation shows B as 700. while i am looking to represent C as sum of A and B in the stacked representation and D by the side. and moreover the dimensions are now changed to revenue type rather than quarter. I am looking at quarter based  dimension.

Can you please help.

[sujeetsingh]

Aditya ,

Can you post your sample my one is showing correct data .

[#8]

can you have a look at the value for B for stacked representation its showing 700.Which should be shown under C as 490.(140+350)