Ask questions

[xiaomihu]

As shown in the figure, how do I show the Target for each team in the second column "teams"

[xiaomihu]

As shown in the figure, how do I show the Target for each team in the second column, "teams," independent of the salesperson

The format in my data source is shown below

Sales person	Team	Sales Target	Team Target
wndjf	业务拓展一部	2000000
zhaoang	业务拓展二部	3000000
黄三	业务拓展三部	5000000
赵四	业务拓展四部	3000000
王五	业务拓展五部	1000000000
李六	销售中心	303000000
	业务拓展一部		100000000
	业务拓展二部		200000000
	业务拓展三部		3000000000
	业务拓展四部		3449999990
	业务拓展五部		5000000000
	销售中心		4000000000

[PrashantSangle]

can you share your data?

[xiaomihu]

The first thing in my reply is my data

Sales person	Team	Sales Target	Team Target
wndjf	业务拓展一部	2000000
zhaoang	业务拓展二部	3000000
黄三	业务拓展三部	5000000
赵四	业务拓展四部	3000000
王五	业务拓展五部	1000000000
李六	销售中心	303000000
	业务拓展一部		100000000
	业务拓展二部		200000000
	业务拓展三部		3000000000
	业务拓展四部		3449999990
	业务拓展五部		5000000000
	销售中心		4000000000

[xiaomihu]

This data is just a sample, I did not put the real data here

[Aditya_Chitale]

The values will automatically align if you add it as a measure. If you want to add as dimension, follow below bethod:

load Team & Target Fields in a separate table and left join it on Main table.

Regards,

Aditya

[xiaomihu]

However, there is a time column in my data, and I only calculate this year's data, should I load the table separately and write the where condition to filter out this year's data, or do I not write the where condition, how should I write the expression when making the table

[Aditya_Chitale]

If you are already loading current year data (Sales & Target both)  in your fact table, then you don't have to apply any condition in resident table. However if you are  fetching Target from a different file (Non resident), then you will have to apply the condition.

Regards,

Aditya

[xiaomihu]

Can you write the expression for me? What I wrote did not achieve the desired effect correctly, thank you

[Aditya_Chitale]

I wont be able to help unless I see the actual data (All columns need to be there) You can jumble the values if you are concerned about data security.

I have shared a screenshot of sample script according to my assumptions of your data. If this doesn't  help kindly share the data.

Regards,

Aditya