Median for duplicated data

[Ken Suga]

Hi,

When considering the median of product sales, if there is a duplicate product between product category "B" and "C",

the median sales of their upper product category A is the value which counts the duplicate product twice.

How can I remove the duplicated value

Example data.

 

 

 

3rd Product Category

2nd Product Category

1st Product Category

Product Number

Sales ($)

 

 

Sports wears

Sports goods

Hobby & Daily

A1

10

 

 

Sports wears

Sports goods

Hobby & Daily

A2

11

 

 

Sports wears

Clothes

Hobby & Daily

A1

10

 

 

Sports wears

Clothes

Hobby & Daily

A2

11

 

 

Woking clothes

Clothes

Hobby & Daily

B1

15

 

 

Rackets

Sports goods

Hobby & Daily

C1

12

 

 

Rackets

Sports goods

Hobby & Daily

C2

13

 

 

 

In this case, product "A1" and "A2" areduplicated products within "Hobby & Daily" category.

When considering the median of sales of "Hobby & Daily", the median is $11 if no operation would bedone.

But correct median is $12.

Does Spotfire have any functions for this matterOr shold I modify and adjust the original dataSpotfire

Sincerely,

Kei