measure help

[nathanpgonzalez]

i have a data set that looks like the following: While i made a expense chart by fiscal year, i want to be able show stats divided by expenses although imagine i have an account column that contains multiple accounts. I want to divide the amount per account divided by the total stats for that dept. can anyone help me with this? thank you

Account Category	Dept Name	Fiscal Year	Amount
Expenses	apples	2014	50
Stats	oranges	2015	3
Hours	bananas	2016	10
Expenses	apples	2014	100
Stats	oranges	2015	7
Hours	bananas	2016	15
Expenses	apples	2014	150
Stats	oranges	2015	13
Hours	bananas	2016	25

[Phil_Seamark]

HI @nathanpgonzalez

Can you please provide a small sample with some dummy account columns along with a mockup of your expected results?

[nathanpgonzalez]

added account.. thanks

Account	Account Category	Dept Name	Fiscal Year	Amount
Office supplies	Expenses	apples	2014	10
costs of goods sold	Expenses	apples	2014	30
Office supplies	Expenses	oranges	2014	15
costs of goods sold	Expenses	oranges	2014	35
Office supplies	Expenses	bananas	2014	15
costs of goods sold	Expenses	bananas	2014	35
Quantity	Stats	apples	2014	3
Quantity	Stats	oranges	2014	5
Quantity	Stats	bananas	2014	18
regular time	Hours	apples	2014	3000
regular time	Hours	oranges	2014	3040
regular time	Hours	bananas	2014	3020
Office supplies	Expenses	apples	2015	12.5
costs of goods sold	Expenses	apples	2015	37.5
Office supplies	Expenses	oranges	2015	18.75
costs of goods sold	Expenses	oranges	2015	43.75
Office supplies	Expenses	bananas	2015	18.75
costs of goods sold	Expenses	bananas	2015	43.75
Quantity	Stats	apples	2015	3.75
Quantity	Stats	oranges	2015	6.25
Quantity	Stats	bananas	2015	22.5
regular time	Hours	apples	2015	3750
regular time	Hours	oranges	2015	3800
regular time	Hours	bananas	2015	3775
Office supplies	Expenses	apples	2016	15
costs of goods sold	Expenses	apples	2016	45
Office supplies	Expenses	oranges	2016	22.5
costs of goods sold	Expenses	oranges	2016	52.5
Office supplies	Expenses	bananas	2016	22.5
costs of goods sold	Expenses	bananas	2016	52.5
Quantity	Stats	apples	2016	4.5
Quantity	Stats	oranges	2016	7.5
Quantity	Stats	bananas	2016	27
regular time	Hours	apples	2016	4500
regular time	Hours	oranges	2016	4560
regular time	Hours	bananas	2016	4530

[v-yuezhe-msft]

Hi @nathanpgonzalez,

What is your expected result based on the above sample data?


Thanks,
Lydia Zhang