Margin_ bottom 10 customers

[georgeD]

Hi everyone ,

I have the [cost] value and the [sales] per transaction and per costumer. in my data there are customers without any transaction. so i want to make a table or a chart with bottom 10 margin customers. 

How could i make this?

Thanks in advance

[vinieme12]

Two Options

1) In your chart add a calculated dimension

=Aggr( if( Rank(-Sum(Margin)) <= 10, [Customer] ), [CustomerID] )  <<< uncheck show null values for this dimension

Or

2)

Add MEasure = sum(Margin)

Add Dimension = Customer

now choose limitation = Fixed Number   >> Bottom >> then input number of values

[georgeD · Accepted solution]

Thanks for your answer.

the second solution , i can't use it because im in trial cloud version and there isn't.

so i,m trying the first solution. i want % margin so wrote this:

=Aggr( if( Rank(-(1-sum([cost])/sum([sales]))) <= 5, [store] ), [store] ).

but a six store appered  in my table (picture). how can i remove it ? did i do something wrong??

[vinieme12]

just uncheck show null values for that dimension

[georgeD]

it seems very simple but in my version there isnt this option (picture), maybe because it is trial , i dont know. I there another way?

[vinieme12]

yep looks like a limitation of the trial version

1) Try option 2 then

2) OR another option is to restrict the Measure and not the dimension

Dimension = [store]

Measure =if( Rank(-(1-sum([cost])/sum([sales]))) <= 5, -(1-sum([cost])/sum([sales])))  )

Then under in properties panel,  Add-On  >> Data Handling >> uncheck Include Zero values

[georgeD]

Umfortunately, neither this work it because i cant find the "Add-On >> Data Handling" 😠.

i ll use the second solution wiht aggr funtion.

thans a lot for your time