Count Customer Code on X-axis

[#1]

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

[agilos_mla]

Please review the attaced qvw.

I can count the customer on the x-axis but in line chart we cannot use a log scale on X.

Then I do the same with the scatter chart but here it's not possible to have a ligne joining the dots. Look if it can suite you.

Michael

[#3]

If(RangeSum(Above(

(Sum({<[Order Year] = {$(=Max())}>}[Sales Amount])

-

Sum({<[Order Year] = {$(=Max())}>}[Purchase Gross Amount])),

0, RowNo()))

/

((Sum(TOTAL{<[Order Year] = {$(=Max())}>}[Sales Amount])

-

Sum(TOTAL{<[Order Year] = {$(=Max())}>}[Purchase Gross

Amount]))) <= v_Pareto_Percentage,1,0)

I am using this function to calculate the 80% Customes demarcation.

But, when i applies this to your logic nothing happens.

moreover i want to see current year data by default and rest as per

selection.

Thanks with Warm Regards:

Rahul Mittal

Informatics & Organization

Business Applications

Deputy Manager

[#4]

help guys please

[#5]

please advise guys..

[#6]

any idea guys