Solved

Dependent dropdowns - building boolean metric?

  • 17 January 2024
  • 2 replies
  • 47 views

Userlevel 2
Badge +4

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.

icon

Best answer by Dmitrii 17 January 2024, 11:16

View original

2 replies

Userlevel 4
Badge +5

Hi @Dmitrii ,


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

Thank you

Userlevel 2
Badge +4

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 :)

Reply