Using
data shown in above table try to build chart which is shown below.
This
chart builds using 1 dimension (Quarter) and 4 measures (Actual Sales, Target
Sales, Actual Profit and Expected Profit).
For
Sales I am showing, yellow color as Actual Sales and blue color as Target
Sales. Or out side bar is Target sales where as inside bar is Actual Sales
For
Profit I am showing, Red color as Actual Profit and Green color as Expected
Profit. Or out side bar is Expected profit where as inside bar is Actual
Profit.
Note:
I did not use any data reshaping technique for this is chart. This chart builds
only with 1 dimension and 4 measures.
Very
interesting challenge. Try this.