How do you intend to use those groupings? If it's just for layout you could create 3 separate sheets and just line the sheets up against each other.
Hi Sateesh Reddy,
I did't get, what exactly you need.
So,Can you Give Clarity to your Question.
Sreendha Reddy Palakolanu
Thanks John for your reply, If it is for layout, you are right we can align as separate sheets.
But, we would also be using the grouping in another worksheets to filter the groups as per selection in drop down, like a filter to have 3 grouped values A,B,C and by picking one of those values would display the related measures.
So thought of checking if there is any other way.
What is the datasource of your actual data.
If it is a flat file - excel , CSV
you could just pivot the measures.
Let me know if that is the case and you need help doing so
As I mentioned in my post above, I would want to create a calculated grouping A,B,C based on the measure values and measure names.
Had those been dimensions, we can directly refer in calculation as
IF dimension='Discount' or Dimension='Number of Records' THEN 'A'
IF dimension='Profit' or Dimension='Profit Ratio' THEN 'B'
But since the default Measure Values and Measure Names cannot be referenced in calculation, I've been looking for a work around.
Hope this clarifies.
Hi Sateesh Reddy, Try to do a calculated field for every measure you want on your viz.
For Calculated A
AVG(Discount) + SUM(Number of Records)
For Calculated B
SUM(Profit) + AGG(Profit Ratio)
For Calculated B
SUM(Quantity) + SUM(Sales)
Then put your Calculated Fields in the Viz.
Hope it would give you an idea.
Thanks Jon, I tried doing it how ever when I drag the new calc fields into viz, it did not give me what I wanted.
See below, the new measures are added to the existing one's instead of a separate column with grouping.
I also tried putting those new cals in rows, that didn't work either.
I will try to tinker in the meanwhile.
Khalid, we use SQL server and its difficult to change the structure for this grouping.
Khalid is right. Pivot options is best to achieve this. I have learned this from him (his replies).
Hi Sateesh are you not able to pivot the table in SQL Server before pulling it into tableau.
Or using custom SQL in tableau?
This will be the best option if you can.