Table/data relationship

[#1]

Dear community,

Attached herewith a sample document, anyone can help to solve this?

I want to find out the tier for corresponding channels, but how to show the tier number without including column Max and Min?

Thanks and best regards,

Chanel

[#2 · Accepted solution]

Hi Chanel,

Does the attached solution work for you?

Rgds,

SK

[er_mohit]

See the attached file

[#4]

Thanks for prompt response!!

May i know why use Column(2)? what is column(2)?

if(Column(2)>0,sum(Spends))

Thanks and best regards,

Chanel

[#5]

Thanks for the reply, but i would like to have the final result as this:

Only 3 rows show the correct tier.

sk123456 has provided the correct result but not sure the column(2) is refer to which data and the purpose of it?

Thanks and best regards,

Chanel

[#6]

So column(2) is the second expression; the one where the Tier is calculated.

if(Column(2)>0, sum(Spends)) results in showing rows where Tier is a non-zero value.

Rgds,

SK

[veidlburkhard]

Hi Chanel,

what sk123456 is meaning is, that you should use your second expression to find your result.
You could as well take If(Tier > 0, sum(Spends)) This gives the same result.

Hope this helps

Burkhard

[#8]

Could you please help to solve how can i have only one row of "over" in Tier column?

Thanks,

Chanel

[preminqlik]

if([Min]>0,'Over',null())