I am new to excel i need help with my calculation, i am trying to take the 50th and 95th percentile from the pivot table dynamically. I need the percentile of each 'Group', and of each 'ID'. Can someone please help me ?My calculation only takes the percentile of each total 'Group'. EXAMPLE1.xlsx