How to display particular ledger account on filtered result by dimension

[Anonymous]

Hi, I want to display the particular account numbers detail from the Dimension result.

Example

I have Ledger account starts from 100000 to 999999, but I need to display the Salary Expenses which is starting from 60000....699999. Please let me know how to define the expression to list the particular account.

Thanks & Best Regards

[Anonymous]

Irrespective of Global filter.

[Anil_Babu_Samineni · Accepted solution]

May be this?

If([Ledger account] >= 60000 and [Ledger account] <= 699999, [Ledger account])

Irrespective of Global filter.

To this? You can manipulate your measure like

Sum({<Global=>} Measure)