Create a simple
crosstab report using GO Data warehouse (Analysis) package.
Use “Product
Line” & “Branch Region” from “Promotion” namespace as
rows & Year as column with “Revenue” as measure.
Now create a data
item “Rank” to find out the ranking of Revenue for each Line &
branch region.
Expression for
Rank data item should contains:
rank(currentMeasure
DESC TUPLE [2013] WITHIN SET [Product line],[Branch region])
It will rank the
measure accordingly for 2013 year.
