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
It sounds like Level of Detail calculation would help here Level of Detail Expressions - Tableau .
For specific recommendations and calculations on your dataset, it would be helpful if you could attach a Tableau Packaged workbook (.twbx) that mirrors your data structure with sample data (or actual data if it isn't confidential).