2 Replies Latest reply on Jan 27, 2019 6:22 PM by Wong Tze Xiang

    Calculated field for percentage

    Wong  Tze Xiang

      Hi guys

       

      I have a table now that ranks "country" by "% of total flow" which is calculated using a table calculation. Im trying to make a calculated field to show percentage of total which is not affected by country filters.

       

      I tried SUM([Total Flow]) / SUM({Exclude [ Country] : SUM(Total Flow)}) but this still gets filtered when i remove countries using my country filter. Does anyone have a way to fix this?