Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need calculate median.
I wrote this code, but this sums the MY_BOOK_ID.
=median({<[YEAR] = {2005}>} MY_BOOK_ID)
I need to count the MY_BOOK_ID, so I wrote the code as
=median({<[YEAR] = {2005}>} count(MY_BOOK_ID))
but this does not work.
Can anyone help me?
Thank you
hi
you need the median for which dimension
for example: assuming your dimension is customer
you could do
median({<[YEAR] = {2005}>} aggr(count(MY_BOOK_ID),Customer))