Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I restrict the values to the top 6, im given a list of the top 5 customers and then the 6th is an accumulation of all the other customers.
So, for instance, if my sales figure was 100
Cust 1 - 10
Cust 2 - 5
Cust 3 - 3
Cust 4 - 2
Cust 5 - 4
Other - 76
I don’t want "others" while showing in the reports (it’s totally distorting the report) and while calculating trends I need those values?
I Have used set analysis in the dimension as aggr(if(rank(sum([Order Amount]))<=0,Customer),Customer)
Please help ASAP
Thanks
I would do that by reducing the Vendor in the expression in place of the dimension, using set analysis :
sum({<Vendor = {"=Rank(sum({$<Year={2010}>}Units))<=3"}>}Units)/
sum(Total <[Year]>[Units])
Look at this sample, % seems to stay the same
Regards,
Thomas
I believe what your problem is that you the show other option turned on.
Goto your charts Properties > Dimention Limits Tab > Uncheck Show Others
Check "Suppress when value is null" on the Dimensions tab.
Hi Michael,
When i am suppressing the null values, we are losing some data. In expression i am using formula as below
=sum([Units])/
sum(Total <year>[Units])
As i am losing some information by suppressing it is showing wrong results...
As per my requirement i that data also but while showing i need to hide ..
Please Help
I'm not suggesting to suppress null values for expressions. I suggest to suppress null values for dimensions. Maybe you need to upload an example to clear my misunderstanding.
Regards,
Michael
Hi Michael,
Please find the attached Qvw. I need to hide those others in line chart.
Thanks
Hi rb,
After checking the dimension limits, uncheck the Others box in the dimensional limits,
Hope it helps
Regards,
ramesh
HI
PFA
Yes, I understood it right first time.
Go to the chart properties, tab Dimensions. Select calculated dimension. After that, check the box "Suppress When Value Is Null". Click OK.
(See attached)
Regards,
Michael
Hi Ramasamy,
Thanks for your reply,I dont wanna suppress the null values it changing the Actuall % values.
Please let me know is there is any other way to hide.
Thanks