Jun 27 2022 02:01 PM
Hello all,
Is there a way to make my own column in a pivot table? I'll provide the existing table for reference:
I would like to make a column that simply outputs the difference between "Declined" and "Total"
I know I can make a column next to it that easily does this but if the column can somehow exist within the existing table, that will be of great help.
Thank you!
Jun 27 2022 02:25 PM
You need to add aggregation within PivotTable, external column doesn't work. In general it depends on how do you calculate Total. As variant creating PivotTable you may add data to data model and create DAX measures for any desired aggregations.
Jun 28 2022 09:45 AM
Jun 28 2022 01:53 PM
I assume you are on Excel Desktop on Windows.
Creating PivotTable add data to data model
Add date to rows in PivotTable Fields pane.
Right click on table name and Add measure
Add 3 measures one by one, it looks like
Measures are
Total:=COUNTROWS( Table1 )
Declined:=CALCULATE( [Total], Table1[IsDeclined] = "Yes" )
Not Declined:=[Total] - [Declined]
Add measures to values
Finally