Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a field called %OrderType, which has values KG or Box. What I want is that when the user select KG or Box, a dimension of a graph is orderer by an expression. This is working. But if there is no expression selected, I want the dimension to be ordered alphabetically.
The dimension is "Especie" and this is the expression that I am using:
=if(%OrderType='KG',Sum(#Kg)/1000,
if(%OrderType='Box',Sum(#Box)/1000,
[Especie])))
Any idea about how to order alphabetically is nothing is selected?
Thanks!
I've found an easier way:
=if(%OrderType='KG',Sum(#Kg)/1000,
if(%OrderType='Box',Sum(#Box)/1000,
null() )))
And select the order alphabetically in the GUI
Thanks!
May be this
=If(%OrderType = 'KG',Sum(#Kg)/1000, If(%OrderType = 'Box', Sum(#Box)/1000, (Count(DISTINCT [Especie]) - Rank([Especie]))))
I've found an easier way:
=if(%OrderType='KG',Sum(#Kg)/1000,
if(%OrderType='Box',Sum(#Box)/1000,
null() )))
And select the order alphabetically in the GUI
Thanks!