Multiple Aggregations within Pivot Table

Hello! Apologies if this has been request before but I was wondering y’all could the ability to aggregate multiple fields within a pivot table? For instance, suppose I have campaign revenue and spend for each day of the week. Right now I could pivot on the campaign name to get revenue or spend for the entire week but not both. It would super helpful if I could get both so I could calculate weekly profit. Anyways, thank you for your time!


I’m not sure I understand this request. Can you share a more explicit example. Maybe with the some sample/dummy data?