0 Replies Latest reply on Oct 25, 2018 11:24 PM by Vishant Nayak

    How to have a static total irrespective of the filters applied?

    Vishant Nayak

      Hi Team,

       

      I am trying to get a static grand total, even if i have filters applied.

       

      Below is the sample screen shot of the example.Attached below the sample test file.I would like to have the grand total fixed even if i filter by city or by month of gender

      For Ex: If i filter by Female for Gurgaon, It should show Female "16" & Grand total "24"

      sheet1.PNG

       

      Thanks,

      Vishant