I am trying to count the number of times a product is On Time and In Full. The way I am trying was nested aggregation, but that isn't allowed. Can any of you help me achieve my goal? The files are attached. Essentially I need to get the percentages on the Comp Pivot sheet in the excel file (on the right hand side). The attached Qlik file is currently trying to imitate the pivot tables on the excel file, to get the final table. Any suggestions? !