10 Replies Latest reply on Jul 2, 2018 11:30 AM by Deepak Rai

    Need help with sorting and grandtotals

    Swapna Chennam

      Hi,

       

      I need help with sorting and grandtotals.

       

      1) I would like to sort by FA_Variance % descending. Tried going into u_prgram and sorting. I couldn't find FA_Variance % in field.

      2) I want the grand totals to change as we change the Top X Selection on right. I know when we use table calc and try totaling it, Tableau totals each and every row without excluding the unranked ones. Any other options other than creating a new sheet and doing Grand totals?

       

      Regards,

      Swapna