Top/bottom calculations

In Cognos Analytics dashboards, you can create a top/bottom calculation that references a different fact table than the metadata items that are used in the visualization.

Note: Tables in dashboards provide only summary totals for data measures that are aggregated by TOTAL when the top or bottom filter is applied. If it is possible, use a crosstab visualization in these cases.