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?
Can you attach a workbook and expected Result?