Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
One of my dimensions is the Account, that has values ranging from 10000 to 99999.
What and where do I need to write in order for the report to show me data for accounts 40000 to 69999 only?
Thanks
Laila
sum({<Account= {">=40000 "}, Account= {"<=69999 "}>}Data)
Will do the trick, assuming your accounts are numeric
in set analysis
sum({<Account={">=40000 <=69999"}>}amount)
Hi,
Check this, as your expression
Sum( {<Account={'>=40000 <=69999'} >} YourExpressionField)
or
Dimension like this,
=If(Account>='40000' and Account<='69999',Account)
-Hirish
Hello Hirish,
Thanks for your reply.
How can I see each account in the range separately and not summed?
When I used your 'if' suggestion, it didn't work.
By the way, the dimension is called 'G_L Account No_' - do I need to enter this full name into the If statement? Should I add an apostrophe? This: If('G_L Account No_'>='40000' and 'G_L Account No_'<='69999','G_L Account No_') didn't work..
Thanks
Laila
Hi,
Check like this, as your dimension,
If([G_L Account No_]>='40000' and [G_L Account No_]<='69999',[G_L Account No_])
-Hirish
Hi Laila,
You could the filter data using "dimension limit" options where you could set your desired expressions.
Best regards,
Kaveri
sum({<Account={">=40000 <=69999"}>}amount)
Hi Laila,
For Calculated Dimension :
If([G_L Account No]>='40000' and [G_L Account No]<='69999',[G_L Account No])
Expression or Measure :
Sum({$<[G_L Account No]={">=40000<=69999"}>} [Measure])
Regards
Hi,
Did you mean entering it in the Dimension, as in the photo attached?
If so, then it's not working, as I get a total column (see beind window in the photo).
I would like to see each account within the range, separately.
Thanks
Laila