1 Reply Latest reply on Sep 19, 2018 3:18 PM by Deepak Rai

    Switch between average and sum in subtotal field

    Ariel Thompson

      Hello,

      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?