Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i want to create a straight chart which analyze sales in intervals (like $00000 <=sales< $100000, $100000<= sales< $500000 etc) .
how can i create this fixed interval to analyze different fields like no. of customers, total sales, total orders etc. for each interval.
You can use "calculated dimention" in charts:
=class( sales, 100000, 'sales' )
or add string inside LOAD statement:
class( sales, 100000, 'sales' ) as [AnalyzingInterval],
You can use "calculated dimention" in charts:
=class( sales, 100000, 'sales' )
or add string inside LOAD statement:
class( sales, 100000, 'sales' ) as [AnalyzingInterval],
thanx for ur reply,
as per ur suggestion i have added following in calculated dimension
=class(SALE_ITEM_NETAMT,100000,'SALES') this leads to two problems:-
1) the interval is not continuous i.e. 0<=SALES<100000, 100000<=SALES<200000 Then 800000<=SALES<900000 etc.
2)sum of no. of customers and orders corresponding to intervals differ from sum showing at the end.
please suggest answer.