STACK CHART ISSUE

[#1]

Month	Quarter	Dim1	Sales1	Sales2
Jan	Q1	A	45	96
Feb	Q1	A	67	97
Mar	Q1	A	45	98
Apr	Q2	A	78	95
May	Q2	A	89	95
Jun	Q2	A	99	95
Jul	Q3	A	89	95
Aug	Q3	A	89	83
Sep	Q3	A	89	84
Oct	Q4	A	89	84
Nov	Q4	A	89	84
Dec	Q4	A	89	84
Jan	Q1	B	94	84
Feb	Q1	B	95	84
Mar	Q1	B	95	84
Apr	Q2	B	95	84
May	Q2	B	95	84
Jun	Q2	B	95	84
Jul	Q3	B	95	84
Aug	Q3	B	95	91
Sep	Q3	B	95	92
Oct	Q4	B	95	92
Nov	Q4	B	95	92
Dec	Q4	B	95	92

I would Like to do a Stacked Bar Chart for the Above Data with Dim1 as First Dimension and Quarter as Second Dimension.

Sales 1 and Sales 2 are the Metrics.

I would like to accomplish the Stacked  Bar Chart as shown in the Attached file.

Any Help is appreciated

[Gysbert_Wassenaar]

See attached qvw.

[#3]

Thnx for the help , but no attachment

[#4]

Got the Attachment, Thnx will review

[#5]

Its very helpful, but Sales1 and Sales2 are a part of a big Data Set, I cant Pivot the other fields in there. like you are doing in the Crosstable

[Gysbert_Wassenaar]

Perhaps a synthetic dimension works. See attached qvw.

[#7]

Your QVW works gr8  for the sample data set I posted, but when I apply the same logic to my actual Data Set, I dont get Quarters  to stack up.

I have a Stack Chart Below with three Dimensions

1)  (vValueListL1) which is ValueList('Case Reserves')

2) ValueList('Actual','Expected')  as Fake Dimension to give me 2 Bars

3) Quarters (Like Q1,Q2,Q3 and Q4)  (they are Cumulative

. Expression is

If($(vValueListL1)='Case Reserves',

(Pick(Match(ValueList('Actual','Expected'),'Actual','Expected'),

Num(Sum({<NEW_YTD_FLAG={'1'}>}(OUTST_INDEMNITY_RESERVE_YTD+OUTST_EXPENSE_RESERVE_YTD)),'#,##0'),

Num(Sum({<NEW_YTD_FLAG={'1'}>}(OUTST_INDEMNITY_RESERVE_YTD+OUTST_EXPENSE_RESERVE_YTD)*0.5),'#,##0'))))

I Expect the Quarters to Stack up on Each Bar.  Please help