Skip to Content

Ranked dimension

I am creating a Bar chart in Webi BI 4.2 SP3, that needs to show Top 8 regions + other regions as "Others". I am able to do that by creating a Rank measure and a dimension.

Measure Top8_region:

=Rank([NS_CY];[Region]) ForEach ([Region])

Dimension as vRegion:

=If([Top8_region]<=8; [Region] ;"Others")

On the cahrt under assign data section I am selecting the vRegion as Category Axis. But when I hover over the bars I am not seeing the value of the region but only a : semicolon. Please see attached image. I am going to be creating a element link to another chart so that I can drill from this chart to another chart. If the hover over shows semicolon the value is not passed to the other chart and therefor not able to drill.

hover-over.jpg

hover-over.jpg (19.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers