Count Customer Code on X-axis

[#1]

how to use calculate dimension so as to have count of customer codes on x-axis.

[MK_QSL]

Dear Rahul,

Michael's answer working on my apps.

[MK_QSL]

I was looking for the same for my apps. Thanks Rahul for raising the question and Thanks Michael for the answer..

[MK_QSL]

Hi Rahul,

If you want to show customer code on X axis and SUM(Actual Sales) on y...

Create a chart with

Dimension

=IF(Aggr(RangeSum(Above(Sum([Actual Sale])/Sum(TOTAL [Actual Sale]), 0, RowNo())),[Customer Code])<0.8,[Customer Code])

Expression

SUM(Actual Sale)

[#5]

Half way it fulfills my requirement , but I need my graph in exact same manner as shown in attachment.

Please advise

[#6]

Thanks it works that way, but I need a separation line between 0.8 and 0.2 members.

[#7]

When I use this function on Live Server, it increases the count drastically.

coz it also consider customers with zero sales

[#8]

Hi,

I couldn't make exactly the same thing (an array "included" in the graph), but 2 nearer displays in attached:

1st with all the info in the title (calculated with a formula), 2nd with 2 separate blocks for 80% and 20%, as separate stacked text objects.

Hope it helps better...

[#9]

80% Customers is not a field in my live server in fact its a label of an expression, how to use this label?

[#10]

and for Order Year = Max Year how to use these  texts

[#11]

any idea guys?????