Please find attached a screenshot shows a Balance Sheet.The dimensions of the Assets and Liabilities are identical drills except for the first dimension of the drill which filters already the Asset or Liabilities accounts. Question: how is it possible to drill in the Assets table without influencing the dimension of the Liabilities table ? In other words, how can the two tables be unlinked at dimension level ?
In QlikView we could not use the drill with alternate states because the states are not taken into account by the drills. The solution we found was to add the dimensions (not grouped) and use Conditions on dimensions. Since in Sense neither alternate states nor conditional dimensions exist, what could be a viable solution ?
Thank you in advance for your help.
Alternates states is totally possible with sense aswell. Firstly check this out:
Also if this dosent help you can go with an extension to achieve it.