Starting from the Data
I am hoping to plot the values sum(X)/sum(Y) for all distinct values of Grouping 3. Basically
Rowlabels vs Results in the table below
The graph should only have 5 points. How do I do this in tableau. (I do not want to do a pivot in excel!)
Here is a working example although I have only replicated the table you requested.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...