1 Reply Latest reply on Nov 5, 2018 12:46 PM by Jennifer VonHagel

    Show two totals - one aggregate and one grouped?

    Anita Lee

      I have data that looks like this:

      Store  SKU  Description  Fulfilled%  Units_Fulfilled

       

      Fufilled% is calculated based on sum(fulfilled units)/sum(requested units). When I display the data, it shows me fulfilled % for the given store. How can I also see the aggregate fulfilled % for the SKU across all stores?

      Additionally, how can I see units_fulfilled across all stores and within each store?

       

      What I want is this:

      Store / SKU / Description / Fulfilled%(for store) /  Fulfilled%(across all stores) / Units_fulfilled / Average_units_fulfilled (agg) / % delta between avg units fulfilled and units fulfilled in store