8 Replies Latest reply: Mar 10, 2014 8:23 AM by Prem Kumar Thangallapally

# Table/data relationship

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

• ###### Re: Table/data relationship

Hi Chanel,

Does the attached solution work for you?

Rgds,

SK

• ###### Re: Table/data relationship

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

• ###### Re: Table/data relationship

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

• ###### Re: Re: Table/data relationship

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

Thanks,

Chanel

• ###### Re: Table/data relationship

See the attached file

• ###### Re: Table/data relationship

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

• ###### Re: Table/data relationship

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