Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Irrespective of Global filter.
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)