Calculated measure in Pivot Table

[fher9728]

Hi!

I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc.

This is an example of the data table which I use:

And this is the pivot table which I have created:

I would like to calculate the Percentage of Rejected message type of the Partners (fail rate owner Partner) / Total orders of the Partner(this would be the total of rejected messages which from all type of fail rate owner), and that the measure could change if a filter the data by date or which whatever I filter it.

I can do it with countifs but i need to get this percentage in the Pivot table.

For example: in high demand por partner 1, it only has 1 count, but the total orders for this Partner are 7, the percentage would be: 1/7 = 14%


I attached the example file and I would be very grateful if anyone could help me.

thanks!

 

[severynm]

Can you add your data here (preferably copy and pasted with xl2bb) to make things a little easier?

 

[fher9728]

Can you add your data here (preferably copy and pasted with xl2bb) to make things a little easier?

example.xlsx
	B	C	D	E	F	G	H	I	J
1	account_owner	city_name	country_name	date_day	fail_rate_owner	Franchise	Partner	reject_message	Week
2	AM 1	City 1	Country 1	5/13/2021	IS_CONFIRMED	Franchise 1	Partner 1	IS_CONFIRMED	W20
3	AM 1	City 1	Country 1	6/13/2021	IS_CONFIRMED	Franchise 1	Partner 1	IS_CONFIRMED	W20
4	AM 1	City 1	Country 1	6/13/2021	IS_CONFIRMED	Franchise 1	Partner 1	IS_CONFIRMED	W20
5	AM 1	City 1	Country 1	6/13/2021	USER	Franchise 1	Partner 1	Cancelled	W20
6	AM 1	City 1	Country 1	6/13/2021	PARTNER	Franchise 1	Partner 1	High Demand	W20
7	AM 1	City 1	Country 1	6/13/2021	PARTNER	Franchise 1	Partner 1	Missing Product	W20
8	AM 1	City 1	Country 1	6/13/2021	PARTNER	Franchise 1	Partner 1	Partner Closed	W20
9	AM 2	City 2	Country 2	6/13/2021	PARTNER	Franchise 2	Partner 2	Partner Closed	W23
10	AM 2	City 2	Country 2	6/13/2021	PARTNER	Franchise 2	Partner 2	Partner Closed	W23
11	AM 2	City 2	Country 2	6/13/2021	PARTNER	Franchise 2	Partner 2	Partner Closed	W23
12	AM 2	City 2	Country 2	6/13/2021	PARTNER	Franchise 2	Partner 2	Missing Product	W23
13	AM 2	City 2	Country 2	6/13/2021	PARTNER	Franchise 2	Partner 2	Missing Product	W23
14	AM 2	City 2	Country 2	6/13/2021	PARTNER	Franchise 2	Partner 2	High Demand	W23
15	AM 2	City 2	Country 2	6/13/2021	PARTNER	Franchise 2	Partner 2	High Demand	W23
16	AM 2	City 2	Country 2	6/13/2021	IS_CONFIRMED	Franchise 2	Partner 2	IS_CONFIRMED	W23
17	AM 2	City 2	Country 2	6/13/2021	IS_CONFIRMED	Franchise 2	Partner 2	IS_CONFIRMED	W23
18	AM 2	City 2	Country 2	6/13/2021	IS_CONFIRMED	Franchise 2	Partner 2	IS_CONFIRMED	W23
19	AM 2	City 2	Country 2	6/13/2021	IS_CONFIRMED	Franchise 2	Partner 2	IS_CONFIRMED	W23
Sheet1

example.xlsx
	A	B
1	fail_rate_owner	PARTNER
2
3	Row Labels	Count of reject_message
4	High Demand	3
5	Partner 1	1
6	Partner 2	2
7	Missing Product	3
8	Partner 1	1
9	Partner 2	2
10	Partner Closed	4
11	Partner 1	1
12	Partner 2	3
13	Grand Total	10
Pivot

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculated measure in Pivot Table

Calculated measure in Pivot Table

Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...

chandoo.org

Calculated measure in Pivot Table

Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...

www.excelguru.ca

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[fher9728]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculated measure in Pivot Table

Calculated measure in Pivot Table

Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...

chandoo.org

Calculated measure in Pivot Table

Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...

www.excelguru.ca

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

sorry, wont ever happen again!