-
1. Re: Different Measure fields in one dimension!
Shinichiro MurakamiJan 21, 2016 9:54 PM (in response to Gatik Vij)
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!
Gatik Vij Jan 21, 2016 10:15 PM (in response to Shinichiro Murakami)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!
Rajeev Pandey Jan 21, 2016 11:01 PM (in response to Gatik Vij)1 of 1 people found this helpfulDear 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.
-
4. Re: Different Measure fields in one dimension!
Gatik Vij Jan 21, 2016 11:06 PM (in response to Rajeev Pandey)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!
Rajeev Pandey Jan 21, 2016 11:14 PM (in response to Gatik Vij)1 of 1 people found this helpfulYou 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
-
6. Re: Hiding measure field in one but display in another dimesnion
Nicola Prime Dec 1, 2016 7:24 PM (in response to Shinichiro Murakami)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
Shinichiro MurakamiDec 1, 2016 8:37 PM (in response to Nicola Prime)
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
Nicola Prime Dec 1, 2016 11:12 PM (in response to Shinichiro Murakami)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...