Median Per Other Column

[Rothschild]

Hi,

I have a table like this:

unit cost	quantity
100	2
200	3
250	1
300	4
350	3

The result of a regular median function on unit cost is 250.

But I want to calculate the median according to quantity:

Median(100,100,200,200,200,250,300,300,300,300,350,350,350) Result: 300.

We do not want to use interval match becouse we have already millions of records.

Does anyone have a solution?

Thanks!

[Chanty4u]

can you try this

AGGR(MEDIAN([Unit Cost]),Quantity)

[Chanty4u]

or

AGGR(MEDIAN(total <unit cost>Quantity),Quantity)

[Rothschild]

Does not work.

[Chanty4u]

median(total <Unit cost> Quantity)

[Rothschild]

Given 1.

[marcus_sommer]

You may try something like this:

=subfield(concat(repeat([unit cost] &',', quantity), ''), ',',
    ceil(substringcount(concat(repeat([unit cost] &',', quantity), ''), ',') / 2))

- Marcus

[Rothschild]

Hi,

Does Anyone have an idea?

unit cost	quantity
100	2
200	3
250	1
300	4
350	3

I have more dimensions.