Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to use calculate dimension so as to have count of customer codes on x-axis.
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
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
help guys please
please advise guys..
any idea guys