6 Replies Latest reply on May 14, 2012 12:57 PM by huanhuan wang

    how to find percentage of positive count in a table?

    huanhuan wang

      Hi,

       

      I've been struggling with this calculation. I want to calculate the percentage of products that have positive impact across all products for different quarters. so for example, for each quarter, i want to see there are 50% of products that are positively being impacted. everytime i try to count the positive impact using 'if >0, then 1, else 0' for each quarter, it gives me 1, same for the products, because its counting the data only showing in the current window. it's a simple hand calculation, but i haven't figured out how to do this in tableau. Anyone can help?

       

      Thanks a lot!