So the trick here is to use the Measure Names and Measure Values that Tableau generates when you load data in. As you can see from the attached, I use the 'measure names' as a dimension, so we can detail the measures and the 'measure values' to plot them correctly. You can use the 'measure names' in the filter, if you don't want to show them all (or once you have them set up, you can drag new measures in to the 'Measure Value' box, just below the colour/shape...tiles.
Hope this makes sense, but please post back if not.
Using Measure Names_Values.twbx 339.2 KB
Thanks for your help.
However I can see that data is now aggregated for all the profits,sales,quantity.But i am looking for individual rows in the table to be plotted.I did try to uncheck the "Aggregate Measures". However still it shows in one row.
I have also attached my tableau file for reference.
Thanks once again for your time.
So in this data you don't have any dimensions. Are you able to add the RowNo to your data as a column? (this is pretty easy to do in SQL, Excel...etc.)
Once you have this, which will be a dimension, you can drag that into the column shelf (if you look at the example I posted, you can drag, say 'Region' onto the Column Shelf and see the charts by region)
Let me know if that does the trick.
Yes Simon..It worked...Thanks a lot for your help...!!