3 Replies Latest reply on Nov 27, 2018 1:30 PM by Oyin T-O

    Show dimension as an average of measure

    Oyin T-O

      Hi, can anyone please advise on how to do this?

      I will like to show my measure in terms of the average and median size of the dimension.


      For example, if I have 10 clients, and a total of $1000 sales, I'd like to see 1) Average sales and 2) Median sales of my 10 clients.

      In this case, client is a dimension and sales is a measure.


      Unable to attach workbook.

      Please and thanks.