Pivot Table

Hi,

Hope you're well.

I have a quick question. I've been trying to build a dashboard and I'm trying to make a calculated field to calculate the percentage of the two columns beside it.

The original data is text rows (eg. student records). I want to find out the % of the fields without a certain field, which is how I analyse the numbers for this task.

XXX || xxxxx || first two columns as a %

data 1 || data 2 || (data 2/data 1 calculation goes here)


How would I do this? I don't want to do this manually, as I want this calculation to be contained within the pivot, so that its dynamic like the rest of it. I've looked it up online but it isn't working like the tutorials show me.


I hope this makes sense and thanks in advance.

Best regards,

Alicia