Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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