Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached qvw.
Thnx for the help , but no attachment
Got the Attachment, Thnx will review
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
Perhaps a synthetic dimension works. See attached qvw.
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