Skip to main content
Solved

Dependent dropdowns - building boolean metric?

  • January 17, 2024
  • 2 replies
  • 294 views

Dmitrii
Master Trendsetter
Forum|alt.badge.img+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

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

2 replies

Issam Moalla
Employee
Forum|alt.badge.img+11
  • Employee
  • January 17, 2024

Hi @Dmitrii ,


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

Thank you


Dmitrii
Master Trendsetter
Forum|alt.badge.img+5
  • Author
  • Master Trendsetter
  • Answer
  • January 17, 2024

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