Grand Total to Show as Average instead of Sum

lthomas

I'm trying to get my Grand Total for Revenue as an example to show as an average instead of a sum in a Mega Table. My Revenue calc is below.

SUM

(CASE

WHEN 


    (`Source` = 'Order Items' AND `OrderItems.Type` = 'SpaceOrder' AND `Rank_DateRunOrderItems` = 1) AND 

	`Reservation.State` != 'Canceled' AND 

    `Enterprise.Name` IS NOT NULL 


THEN 


	`Amount.NetValue`


ELSE


	0

END)

TommyDenn

You should be able to follow the referenced steps. This article references AVG but should work as SUM too…

https://community-forums.domo.com/main/discussion/61660/pivot-table-total-and-subtotals-are-not-the-sum-but-the-aggregation-function

TommyDenn

@lthomas If the earlier doesn't work - Use a fixed function in the Beastmode. I think this option is best.

https://domo-support.domo.com/s/article/4408174643607?language=en_US