9 Replies Latest reply on Dec 1, 2016 11:21 PM by Shinichiro Murakami

# Hiding measure field in one but display in another dimesnion

Hello,

I have a requirement to display different measure fields under one single dimension.

For instance below is the default layout of Tableau for the kind of view i am trying to make-:

but what i want is something like this-:

I have omitted "Order Quantity" measure from "Region"  Dimension but only in case if it is "International" whereas "Order Quantity is visible in all other regions.

Thanks in advance.

• ###### 1. Re: Different Measure fields in one dimension!

Gatik,

This might be very complicated solution, but something close...

Use just one calculated field.

[Calculation 1]

if  [Region]="South" then "IN" ELSE "OUT" END

*** this case only south is hidden by coloring white.....

For detail procedure to create this type of table,(different format for specific field) follow this post.

Calculation logic is applying to all measure values?

Thanks,

Shin

• ###### 2. Re: Different Measure fields in one dimension!

Hello Shin,

Thanks for your support but in real scenario i have to use around 13-15 measure values that is why the method suggested by you won't suffice the requirement.

Along with that i don't want the column name/pane to be visible too(completely hiding in one and displaying in another).

• ###### 3. Re: Different Measure fields in one dimension!

Dear Gatik,

Could you please check the below approach and let me know your thoughts on this.

Step1 : Create a Calculated Field as per the below logic. You can select any region based on your convenience.

if [Region]="Central" AND ([Order Quantity])>1 then [Order Quantity]*0

Elseif [Region]="East" then [Order Quantity]

Elseif [Region]="West" then [Order Quantity]

Elseif [Region]="South" then [Order Quantity]

END

Step 2: Now create another calculated Field as mentioned Below.

If [Order Quantity 1]=0 then "Hide" Else "Show" End

Step 3: Drag this Newly created Calculated Field to the Filter Shelf and Select "Show" as an option.

Step 4 : Drag the required Measures and dimensions in the view and now you can able to see the "Order Quantity 1(First Calculated Field)" column for central region is not showing any value while for other region you are getting an order quantity .

Please let me know your thoughts on this.

1 of 1 people found this helpful
• ###### 4. Re: Different Measure fields in one dimension!

Dear Rajeev,

The solution seems to solve half of the requirement but what remains is how to hide that column in which data is not coming??

In your sample workbook provided how can i hide "Order Quantity 1" in central whereas display in east.

Thanks & Regards

• ###### 5. Re: Different Measure fields in one dimension!

You can do this in dashboard.

Step 1: Create a new Blank sheet. Remove the Grid lines by changing the below option

Step 2: Drag this new sheet and put it on top of the Quantity 1 name and hide the name. This is only way of hiding the column.

Your final result will look like this

1 of 1 people found this helpful
• ###### 6. Re: Hiding measure field in one but display in another dimesnion

Hi Shin,

I came across the above when trying to hide certain measures within a particular month.

I  realise this was posted some time ago but I have tried to recreate the above, and I am having two issues:

1) How do you get the figures aligned? Mine is looking like the below:

2) How do you get the "In/Out" in the Black/white colour? I can't find black or white to select in the colours selection? In the above it is      working because I did it in the same workbook as your example but when I try to apply to my own data, I can't find the option.

Many Thanks

Nicola

• ###### 7. Re: Hiding measure field in one but display in another dimesnion

Nicola

From a glance, you are putting sum() filed for column, but mine is putting min(number of record) and put sum() as label.

See below link for detail.

For color, double click on the color next to text in the color legend, then you see another window to choose custom color.

Shin

• ###### 8. Re: Hiding measure field in one but display in another dimesnion

Hi Chin,

Thanks for your response.

Great - I've changed from SUM to MIN and now it is working.

My only issue now is finding the white/black option - I can't understand it but when I select, there is no option for these two colours - none of the pallets have pure black/white, any ideas? I'm sure previously I have seen such an option...

• ###### 9. Re: Hiding measure field in one but display in another dimesnion