Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

0 Replies