i am trying to short the second dimension. I have tried all the possible way to short.
Short the second dimension alphabetical order.
Thank's in advance.
Sir previously it was showing the less dimensions and now it's more. And instead of this I want the dimension to be shorted alphabetically not the expression by number.
from A-Z or Z-A
The comments in your QVW is different to the post above
See attached updated version
but why are you changing the dimension.
please short this dimension
Dimension 1 : =if(not(match(MetricID,3,4)),MetricID)
Dimension 2 : =Dual(Company,Aggr(Sum(Count),MetricID,Company))
expression : sum(Count)
Buddy the dimension is already sorted without this expression.
Yes it is but it is not the actual dimension that i wanted to short.it is having more attributes than before.
"it is having more attributes than before."
can you give an example by highlighting the ones that are extra!!!
before it was less numbers in dimension 2
and see your attachment it is having large number which i restricted using dual function.
just check Suppress zero values in presentation tab
It is due to the dimension not any other representation setting.
yes, check that box
buddy without checking that box u are able to see the result ?
i want this result to be shorted.
i want code to be shorted alphabetically not any other values for below dimension and measure :
how is it sorted in the app i attached? is that not alphabetical?
the file that u have attached is having different dimension that i required.
your dimension :Company
my dimension :Dual(Company,Aggr(Sum(Count),MetricID,Company))
both is having different output plz try to understand
if i will suppress zero value in your file that it might be same but in that case i will loose the zero value.Which is showing in my result as you can see in screenshot.
Retrieving data ...