Calculating specific columns from a pivot

Hey there, I am trying to figure out how to make calculations on specific columns from a pivot. In this example, I want to look at Monday sales, Tuesday-Friday sales, and Saturday-Sunday sales. I ran the query with sales by individual days, but I cannot figure out how to do sums of the specific days.

1 6 18.4K
6 REPLIES 6
Top Labels in this Space