I am trying to replicate the below report in tableau.
I have the columns s1 and q1 in 2 separate dropdown menu and the report is to be parameterized.
The value in display is sum(rpm) field from the database.
The final column will be the sum of RPM of both s1 and q1. Every day will have only 1 row of data.
Now how do I develop such a report? Also on change of the dropdown,the corresponding column has to change and display its sum(rpm) for the day.
Please advise with a sample workbook.
Any help on this?