Pivot Table Ratio between 2 Columns

[goko]

Consider the following table

Date	Invited	Attended	isNotAbsent
Jan-23	Wade	attended and performed	1
Feb-23	Dave	attended	1
Mar-23	Seth	absent
Apr-23	Ivan	attended and performed	1
May-23	Riley	absent
Jun-23	Gilbert	absent
Feb-23	Jorge	attended	1
Mar-23	Dan	attended and performed	1
Feb-23	Brian	attended and performed	1
Mar-23	Roberto	attended	1
Jun-23	Ramon	absent
Feb-23	Miles	attended and performed	1
Mar-23	Liam	absent
May-23	Nathaniel	absent
Jun-23	Ethan	attended and performed	1
Feb-23	Lewis	attended	1
Feb-23	Milton	absent
Mar-23	Claude	absent
Jun-23	Joshua	attended	1
Feb-23	Glen	attended and performed	1
Jan-23	Harvey	absent
Feb-23	Blake	absent
Mar-23	Antonio	attended and performed	1
Apr-23	Connor	attended	1
May-23	Julian	absent
Jun-23	Aidan	attended and performed	1
Feb-23	Harold	absent
Mar-23	Conner	absent
Feb-23	Peter	attended and performed	1
Mar-23	Hunter	attended	1
Feb-23	Eli	attended and performed	1
Mar-23	Alberto	attended and performed	1
Jun-23	Carlos	attended	1
Feb-23	Shane	attended and performed	1
Mar-23	Aaron	attended	1
Mar-23	Marlin	absent
Jun-23	Paul	absent
Feb-23	Ricardo	attended	1
Apr-23	Hector	absent
May-23	Alexis	attended and performed	1
Jun-23	Adrian	attended	1
Feb-23	Kingston	attended and performed	1
Mar-23	Douglas	absent

I want to achieve the following but in pivotTable

Date	Invited	Attended	Attendance Ratio
Jan-23	2	1	50%
Feb-23	14	11	79%
Mar-23	12	6	50%
Apr-23	3	2	67%
May-23	4	1	25%
Jun-23	8	5	63%

Is it possible?

 

[goko]

Ok I was eventually able to solve the this.

I had to modify the table to the following and than added a calculated field = 'T Invited'/Attendance

Date	Invited	Attended	T Invited	Attendance
1-Jan-23	Wade	attended and performed	1	1
1-Feb-23	Dave	attended	1	1
1-Mar-23	Seth	absent	1	0
1-Apr-23	Ivan	attended and performed	1	1
1-May-23	Riley	absent	1	0
1-Jun-23	Gilbert	absent	1	0
1-Feb-23	Jorge	attended	1	1
1-Mar-23	Dan	attended and performed	1	1
1-Feb-23	Brian	attended and performed	1	1
1-Mar-23	Roberto	attended	1	1
1-Jun-23	Ramon	absent	1	0
1-Feb-23	Miles	attended and performed	1	1
1-Mar-23	Liam	absent	1	0
1-May-23	Nathaniel	absent	1	0
1-Jun-23	Ethan	attended and performed	1	1
1-Feb-23	Lewis	attended	1	1
1-Feb-23	Milton	absent	1	0
1-Mar-23	Claude	absent	1	0
1-Jun-23	Joshua	attended	1	1
1-Feb-23	Glen	attended and performed	1	1
1-Jan-23	Harvey	absent	1	0
1-Feb-23	Blake	absent	1	0
1-Mar-23	Antonio	attended and performed	1	1
1-Apr-23	Connor	attended	1	1
1-May-23	Julian	absent	1	0
1-Jun-23	Aidan	attended and performed	1	1
1-Feb-23	Harold	absent	1	0
1-Mar-23	Conner	absent	1	0
1-Feb-23	Peter	attended and performed	1	1
1-Mar-23	Hunter	attended	1	1
1-Feb-23	Eli	attended and performed	1	1
1-Mar-23	Alberto	attended and performed	1	1
1-Jun-23	Carlos	attended	1	1
1-Feb-23	Shane	attended and performed	1	1
1-Mar-23	Aaron	attended	1	1
1-Mar-23	Marlin	absent	1	0
1-Jun-23	Paul	absent	1	0
1-Feb-23	Ricardo	attended	1	1
1-Apr-23	Hector	absent	1	0
1-May-23	Alexis	attended and performed	1	1
1-Jun-23	Adrian	attended	1	1
1-Feb-23	Kingston	attended and performed	1	1
1-Mar-23	Douglas	absent	1	0

eventually getting the result that I wanted

Row Labels	Sum of T Invited	Sum of Attendance	Sum of Field1
Jan	2	1	50%
Feb	14	11	79%
Mar	12	6	50%
Apr	3	2	67%
May	4	1	25%
Jun	8	5	63%
Grand Total	43	26	60%

The clue to solving the issue was that calculated fields only evaluate to sum