FIELD CATEGORIZATION

[naveenashokan94]

I am having the Data set as the follwing which i have attached below,

what I need is , I want to show the name and price of bike which are not listed in TOP10,TOP20,TOP30 but present only in 'IMPORTED'

Looking forward for Solutions,

Thanks in advance,

NAVEEN.A

[vishsaggi]

Can you share some sample data where you have the expressions for TOP10, TOP20 and TOP30. Image does not help.

[shiveshsingh]

Calculated dimension can help

if(isnull(Flag10) and isnull(Flag20) and isnull(Flag30) and Flagimported = 'Imported',NAME) as NAME

[vishsaggi]

How do you know if those Flag10, Flag20 and Flag30 are fields rather expressions? Just checking.

[shiveshsingh]

Just gave an idea , if they are expressions then this will  not work

[naveenashokan94]

Those data sets are huge...thats why I shared the image...will try to attach the sample if possibe!!

[jyothish8807 · Accepted solution]

You can also try like this :

Create a calculated dimension:

if(len(trim(Flag10&Flag20&Flag30)) = 0 and Flagimported = 'Imported',NAME)

exp: sum(Price)

Br,

KC

[naveenashokan94]

Thank you so much@Jyothish KC

It worked fine...Thaks for your suggestion.

[naveenashokan94]

Iam having one more Issue...
The issue is i need to Show the name and Price of bikes which are lot listed in any of the categories(The bike should not be listed in TOP10, TOP20, TOP30, and imported.)

Thanks in advance.

[jyothish8807]

try like this then:

if(len(trim(Flag10&Flag20&Flag30&Flagimported)) =0, NAME)

Br,

KC