Dependent dropdowns - building boolean metric?

  • 17 January 2024
  • 2 replies

Userlevel 2
Badge +5

Can somebody assists me with a formula for a Boolean metric required for the dependent drop-down, when I want to connect Type of report with Account groups:


The formula below is incorrect and cannot wrap my head around how to make it by dimensions.


Best answer by Dmitrii 17 January 2024, 11:16

View original

2 replies

Userlevel 5
Badge +9

Hi @Dmitrii ,

Could you provide more clarifications and share the formula you are working on?

Thank you

Userlevel 2
Badge +5

I solved it as follows:

'Grouping 2 - lower'.'Links to upper group'.'Group type'[ADD: 'Balance or P&L'] = 'Balance or P&L'

Here is the result that I use for dependent dropdowns


Question resolved :)