When clicking Revenue
When click Product cost
Use crosstab: As only active report variable can only specified by data item, it is difficult to find function to retrieve measure caption. In other word, when clicking value 914M, active variable should be specified as ‘Revenue’; when clicking value 547M, active variable should be specified as ‘Product cost’. The only solution is to split it as multiple crosstab, each crosstab will specify one data item, such as ‘Revenue’ or ‘Product cost’. Even with multiple crosstabs, the column title still cannot be share the same highlighted area, as column title can is not specified as click region.
Use List: It will have the same problem as crosstab. This approach won’t be very flexible, as crosstab give data more flexibility to display.
Use static repeat table: This solution provides the maximum display flexibility, but it still like crosstab and list to have their limitations.
Use static repeat table with singleton to achieve the needed functionality. Each static repeat table has only one cell. Each cell will contain normal table, and each table will have singleton. All query can be shared.
- Create a table with two rows, where the first one contains table with two static repeat table. Each static table has only one cell. the second row will contain a deck with two cards – page1 and Page2
- To make the title with measure together, we need to put both value and title together. Please see page structure below.
- Variable vPage will be specified by both active reportable table, and then pass it to deck to make it take in effect .