Calculated measure in Pivot Table

fher97

New member
Joined
Jun 14, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2019
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:

1623629878531.png

And this is the pivot table which I have created:

1623629917661.png

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!
 

Attachments

  • example.xlsx
    15.7 KB · Views: 7
Back
Top