I have a table that currently displays shipment totals for each day by row. The [shipments] variable is an aggregate. I would like to be able to toggle the subtotal field between average and sum for each row. From what I understand, the subtotal field can only be one or the other. So I've tried using a Table calculation.
I have a parameter with "average" and "sum" and have tried using that with a Table Calculation to show WINDOW_AVG[shipment] when SIZE()<20 else [shipment]. I still have my subtotal field turned on. However, every time I set my parameter to "average", the subtotal field still displays the sum of the row.
Is there another way to force the subtotal field to toggle between these two?