Hi!
I've made an histogram where I see:
- Numbers of Packages
- Time (Lead Time from Arrived to Shipping)
I need to study the Lead Time when i 've reached up 85% of numer packages ordered by Lead Time Ascendend
(see picture under)
![perry7_0-1651475817966.png perry7_0-1651475817966.png](https://community.qlik.com/t5/image/serverpage/image-id/78403iCF5A7A33010D4A8F/image-dimensions/887x309?v=v2)
I've to put this result on Pivot Table, where i have categories variables as Area, Store, Region, Package Type, Good Type...
The formula of my goal is:
=Max({< [LeadTime]={"<= $(=fractile([Lead Time],0.85))"} >} [Lead Time])
But if I put it in a Pivot, I ve :
![perry7_1-1651475817969.png perry7_1-1651475817969.png](https://community.qlik.com/t5/image/serverpage/image-id/78404i8C9F5C34AC6327BA/image-dimensions/737x223?v=v2)
The result is not modular when i change the categories variables, but its always the same!
What shall I write ??
Hoping a solution,
marco
![perry7_2-1651475818022.png perry7_2-1651475818022.png](https://community.qlik.com/t5/image/serverpage/image-id/78402i1D57849DFF74354F/image-dimensions/32x32?v=v2)