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

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.

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

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

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.

Such a simple view, it required 100 steps!! - Having Multiple KPIs - - Still Struggling with Excel ?? <Tableau's Room>

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

Shin

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...