Exclude value(s) from dimension base on another table

[Anonymous]

Hi all,

I am a student and doing a school BI assignment and need help. Thanks in advance.

I have 2 tables: Salesperson_Master and SalesRecords_History

I want to analyse only active Sales Person from SalesRecords_History table, those highlighted in yellow.
- S4 have left
- S1 use to be responsible for C3, which now is taken care of by S2

It should not be at script level since salesperson_master table is always updated.

I will be using barchart and dimension as SalesPersonID. I will be only interested in the total salesAmount of S1, S2 and S3.

Thanks.

[Anonymous]

This is just a simplify view of my assignments. There are multiple tables and fields have to renamed to eliminate synthetic keys.

[Sergey_Shuklin]

Hello!

I didn't catch a point of this part "S1 use to be responsible for C3, which now is taken care of by S2".

And what your expected output should be? What analytics you have to do? (instead of total sales amount)

[Anil_Babu_Samineni]

Welcome to the community, And even your first thread you are creating that's really neat and clean to answer.

Perhaps this?

Sum(If(SalesPersonID_Master = SalesPersonID,SalesAmount))

OR

Count(If(SalesPersonID_Master = SalesPersonID,SalesAmount))

OR

Sum({<SalesPersonID_Master = {"=SalesPersonID_Master=SalesPersonID"}>} SalesAmount)

[Anonymous]

Hi,

"S1 use to be responsible for C3, which now is taken care of by S2".

It just meant to say in the past Customer3 is managed by SalesPerson1, now Customer3 is managed by SalesPerson2.

Essentially I will want to analyst the amount of sales for S1,S2 and S3. Not interested in S4 as he is no longer in the organisation.

Thks.

[Anonymous]

Hi, thanks for the reply. However the results is not what I am looking for.