Understanding the Error: TypeError No Matching Signature Found When Pivoting a DataFrame

Grouping Data by Foreign Key and Date with Total by Date Using Conditional Aggregation