Grouping dimension values

[venkatasuresh]

Hi Guys,

Need your help on below query.

One of my pivot table i have used dimension called 'Distributor'

under Distributor i want to display Others and null values '_' together 

EX:

Distributor	Quantity	sales
Amazon	14	4000
flipkart	12	2000
ebay	8	3000
sanapdeal	6	1200
Others	18	3400
-	27	6000

Expected output:

Distributor	Quantity	sales
Amazon	14	4000
flipkart	12	2000
ebay	8	3000
sanapdeal	6	1200
Others	45	9400

i have added the calculation dimension like below

=if(Match([Distributor],'Amazon','flipkart','ebay','sanapdeal','Others'),[Distributor],'Others') 

but its not given expected out put 

 Thanks,

Suresh V.V

[Or]

I would recommend doing this in the script, by setting up a new field, Distributor_Without_Nulls, which would have the formula:

if(isnull(Distributor),'Others',Distributor) as Distributor_Without_Nulls

If you don't want to do this script-side, you could also use this code in a calculated dimension, but in this case, users would not be able to click "Others" and get the correct selections applied, I think.

[Saravanan_Desingh]

One solution is.

=If(IsNull(Distributor) Or Distributor='Others', 'Others', Distributor)

Script:

tab1:
LOAD If(Distributor='',Null(),Distributor) As Distributor, Quantity, sales INLINE [
    Distributor, Quantity, sales
    Amazon, 14, 4000
    flipkart, 12, 2000
    ebay, 8, 3000
    sanapdeal, 6, 1200
    Others, 18, 3400
    , 27, 6000
];

[venkatasuresh · Accepted solution]

Hi Thank you so much for your kind support:)

I fixed this issue by using apply-map  function

I tried both of your solutions its working fine on my local desktop,once i publish the application on access point 

i can see the null value '_'  , the i tried apply map the issue got fixed.

Thanks,

Suresh V.V