substep adding cross table to the report suppose you want to know the average interest rate paid by directors of risk group in this case you want to get measure (interest ratefor combination of two dimensions (job title and risk gradethis can be achieved with pivot table such as in figure figure an example of pivot tableshowing the average interest rate paid per job title/risk grade combination adding pivot table to report takes six stepsas listed below and shown in figure choose chart--choose pivot table as the chart and place it on the report screenresize and position to your liking add measure--click the add measure button inside the chart and select int_rate choose an aggregation method--avg(int_rateadd row dimension --click add dimensionand choose emp_title as the dimension add column dimension--click add datachoose columnand select grade format the chart--on the right panefill in average interest rate as label