Hi! I'm trying to use a pivot table from excel, but I can't seem to make it usable on tableau.
I also upload the original file. I'm counting the number of "Yes" votes and dividing it by the number of total votes (subtracted of "Not a member" votes).
What changes should I make to the pivot table excel file? Or should I just try to analyse the original file on tableau?
I'd be grateful if anyone can help me.
I would use the UNVotes1-72 sheet. You have far more dimensional control for displaying things by year and by voteID. Tableau can do the math that you're looking to do.