Median Value in Pivot by Aggregation

[#1]

Hi, 

I need to create a median value for a whole 'Dimension' within a Pivot Chart.

In the screenshot below I have  created a Median 'Cost' for each User (column D) and I now need to create a median for the 'Centre'

for a comparitor.  Is this possible in Qliksense?

Many thanks for any help!

TJM

[sunny_talwar]

Did my response here resolved the issue? Or is this something else?

Aggregate & Upper Quartile Help

[#3]

Hi,

This is a similar application.  I am trying to calculate median for group.  My base fields are  :

• total calls
• Cost per call

I need to sum these and find the median cost per call for the Centre (where we have upto 20 centres and anywhere from 5 to 20 call handlers per centre) ....

Hope this makes sense, i tried your Qlikview Solution - but getting null values in Sense....

[sunny_talwar]

Sum what exactly? Median Cost or Sum of Cost per call? I am not completely sure I understand. Would you be able to share a sample?

[#5]

my mistake - your solution fits perfectly.

Many thanks,

TJM

[sunny_talwar]

Awesome

Please close this thread down, I guess by marking assumed answer

Best,

Sunny