0 Replies Latest reply: Nov 1, 2016 7:34 AM by Marc Victor RSS

    How do I get % in Pivot Table Measurement - Not Count

    Marc Victor

      I have a spreadsheet that contains the result (Win/Lost/Even) of an Asset (EURUSD/Gold/Google) that I traded on a day which was provided by a Signal Provider, i.e.:

      Inline images 3

       

      All I want to know is "Which provider supplied the best (most Wins) signals for the Quarter/Month/Week/Day, and also trending on days of the week(i.e.: Are signals provided by provider 1 mostly good or bad on Mondays?)

       

      I have the Pivot Table setup (correctly I think), but the Result column which is used as a Measure, shows the Count of Win/Lost/Even entries and not the % if Win entries for that day ... I'm stumped

      Inline images 4