Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
See this sample
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..
You can try to implement it by using the expression group as i have made one in this sample
Thanks sujeet.
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.
Aditya ,
Can you post your sample my one is showing correct data .
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)