In Excel pivot tables, when there are multiple Values to be aggregated, you can have those results displayed either displayed horizontally or vertically under each Column value. In BI's Matrix visualizaiton, I can certainly achieve the horizontal display - but can I achieve the vertical display? This vertical display is very useful in certain analyzes. Examples are below.
Regards,
--------------------
Rough Example - horizontal
Jan Feb Mar
Revenue Cost Margin Revenue Cost Margin Revenue Cost Margin
Customer A 10 7 3 15 8 7 20 16 4
Customer B 25 13 12 30 24 6 35 27 8
-----------------------
Rough Example - vertical
Jan Feb Mar
Customer A Sum Revenue 10 15 20
Sum Cost 7 8 16
Sum Margin 3 7 4
Cusotmer B Sum Revenue 25 30 35
Sum Cost 13 24 27
Sum Margin 12 6 8
