Add a calculated field in a workshop pivot table

[LenStringer]

I created a pivot table in a workshop app that counts on time and late receipts by supplier. I would like to add ca calculated field that is the ration of on time receipts to total receipts

[Phil-M]

Hi @LenStringer. This sounds like a pretty straight forward requirement to me. Let me help you set it up.
I assume you structured your pivot table in a way that you have some form of supplier > product hierarchy on the row groupings and the columns are time based, right? So maybe your data looks similar to mine here:

Note upfront: To realize the % calculation it helps to have on each of your (purchase?) orders assigned with an on-time-flag that is either 1 or 0 - it does not need to be numeric, bool is also fine. But don’t use string like “Yes” or “No” because this you can not aggregate.

Here is how the three measures are set up:

Total:

On-Time Count:

On-Time %:

So you see that the ratio is just a repetition of the first two measures itself and then the division out of them both.
I hope this helps you to set up your pivot

[LenStringer]

Thanks Phil-M! That worked like a charm!