Skip to main content

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.

Hi @Dmitrii ,


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

Thank you


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