I have the following table that is using window functions in beast mode to calculate pipeline coverage.
I have these window functions for calculating the visible visible columns:
Pipeline/AOP
SUM(CASE WHEN LEFT(`Stage`, 1) != '7' THEN `Pipeline` END)
/
MIN(`AOP`)
OVER (PARTITION BY `Selling Lane`)
Late Stage/AOP
SUM(CASE WHEN LEFT(`Stage`, 1) IN ('3','4','5','6') THEN `Pipeline` END)
/
MIN(`AOP`)
OVER (PARTITION BY `Selling Lane`)
Each Selling Lane has a specific AOP and there are multiple records for each selling lane.
The issue is the total row is showing the sum for each of the Selling Lanes' coverages instead of the total aggregation. I'm assuming this is because I have the partition by clause included in there, which is needed to calculate it for each selling lane. Is there a way that I can get the total row to show the aggregate overall instead of the sum for each of the selling lanes?