Public demo. Rearrange, save and share layouts as you like — the data is reset every hour. About Warp Pivot Docs Support filamentphp.com Buy a license
Top products

Categories ranked by sales, each with its ten best-selling products and the rest added up as "Other". The ranking and the cut are done in the database with orderByValue() and limit(10).
{"label":"Top products","title":null,"expandable":true,"height":null,"expanded":{"rows":0,"columns":null},"configurable":true,"layout":{"rows":["product.category","product"],"columns":["sold_at:year"],"filters":[],"values":[{"name":"amount_sum","showAs":"value"},{"name":"share","showAs":"percent_of_parent_row"}]},"fields":{"dimensions":[{"name":"product.category","label":"Category","limit":null,"date":false},{"name":"product","label":"Product","limit":{"count":10,"bottom":false},"date":false},{"name":"sold_at:year","label":"Year","limit":null,"date":true},{"name":"channel","label":"Channel","limit":null,"date":false},{"name":"store.prefecture.region","label":"Region","limit":null,"date":false}],"measures":[{"name":"amount_sum","label":"Sales","function":"sum","aggregations":["sum","avg","min","max","count","stddev","variance","median","product"]},{"name":"share","label":"Share of category","function":"sum","aggregations":["sum","avg","min","max","count","stddev","variance","median","product"]},{"name":"count","label":"Orders","function":"count","aggregations":[]},{"name":"quantity_sum","label":"Units","function":"sum","aggregations":["sum","avg","min","max","count","stddev","variance","median","product"]}]},"conditions":{"label":[{"value":"equal","label":"equals"},{"value":"not_equal","label":"does not equal"},{"value":"contains","label":"contains"},{"value":"not_contains","label":"does not contain"},{"value":"begins","label":"begins with"},{"value":"not_begins","label":"does not begin with"},{"value":"ends","label":"ends with"},{"value":"not_ends","label":"does not end with"},{"value":"greater","label":"is greater than"},{"value":"greater_equal","label":"is greater than or equal to"},{"value":"less","label":"is less than"},{"value":"less_equal","label":"is less than or equal to"},{"value":"between","label":"is between"},{"value":"not_between","label":"is not between"}],"value":[{"value":"equal","label":"equals"},{"value":"not_equal","label":"does not equal"},{"value":"greater","label":"is greater than"},{"value":"greater_equal","label":"is greater than or equal to"},{"value":"less","label":"is less than"},{"value":"less_equal","label":"is less than or equal to"},{"value":"between","label":"is between"},{"value":"not_between","label":"is not between"}],"date":[{"value":"equal","label":"equals"},{"value":"not_equal","label":"does not equal"},{"value":"before","label":"is before"},{"value":"before_equal","label":"is on or before"},{"value":"after","label":"is after"},{"value":"after_equal","label":"is on or after"},{"value":"between","label":"is between"},{"value":"not_between","label":"is not between"},{"value":"last","label":"in the last"},{"value":"current","label":"in this"},{"value":"next","label":"in the next"}],"periods":[{"value":"day","label":"day"},{"value":"week","label":"week"},{"value":"month","label":"month"},{"value":"quarter","label":"quarter"},{"value":"year","label":"year"}]},"showAs":[{"value":"value","label":"Value"},{"value":"percent_of_row_total","label":"% of row total"},{"value":"percent_of_column_total","label":"% of column total"},{"value":"percent_of_grand_total","label":"% of grand total"},{"value":"percent_of_parent_row","label":"% of parent row"},{"value":"percent_of_parent_column","label":"% of parent column"},{"value":"difference_from_previous","label":"Difference from previous"},{"value":"percent_difference_from_previous","label":"% difference from previous"},{"value":"running_total","label":"Running total"},{"value":"index","label":"Index"},{"value":"rank","label":"Rank"}],"aggregations":[{"value":"sum","label":"Sum"},{"value":"avg","label":"Average"},{"value":"min","label":"Minimum"},{"value":"max","label":"Maximum"},{"value":"count","label":"Count"},{"value":"count_distinct","label":"Distinct count"},{"value":"stddev","label":"Standard deviation"},{"value":"variance","label":"Variance"},{"value":"median","label":"Median"},{"value":"product","label":"Product"}],"calculatedValues":true,"recordFormulaColumns":[],"charts":true,"chartTypes":[{"value":"column","label":"Column"},{"value":"stacked_column","label":"Stacked column"},{"value":"bar","label":"Bar"},{"value":"stacked_bar","label":"Stacked bar"},{"value":"line","label":"Line"},{"value":"area","label":"Area"},{"value":"column_line","label":"Column and line"},{"value":"pie","label":"Pie"},{"value":"donut","label":"Donut"},{"value":"scatter","label":"Scatter"}],"forms":[{"value":"compact","label":"Compact"},{"value":"classic","label":"Classic"},{"value":"flat","label":"Flat"}],"display":{"form":"compact","totals":{"rows":true,"columns":true},"totalsPosition":"bottom","subtotals":{"rows":true,"columns":true},"mode":"grid","chart":{"type":"column","measure":0}},"savedViews":true,"urlKey":"pivot","drillDown":true,"key":"App\\Filament\\Pages\\TopProducts","model":"10e2d0533b5b8e5d","cellActions":[],"cellClickAction":null,"exportFormats":["xlsx","csv","pdf","png"],"exportFileName":"top-products","exportHeader":null,"exportFooter":null,"initialState":null,"labels":{"total":"Total","subtotal":":label Total","empty":"No data to show","loading":"Aggregating…","summary":{"count":"Count :count","sum":"Sum :sum","average":"Average :average"},"expanded":"expanded","collapsed":"collapsed","other":"Other","chartTooMany":"Showing the first :shown of :total.","chartEmpty":"Nothing to chart","menu":{"expand_level":"Expand every :label","collapse_level":"Collapse every :label","filter":"Filter :label…","sort_asc":"Sort :label A to Z","sort_desc":"Sort :label Z to A","sort_rows_desc":"Sort rows largest first","sort_rows_asc":"Sort rows smallest first","sort_rows_off":"Original order","drill_down":"Show the records","copy":"Copy","value_settings":"Value settings…","auto_width":"Fit the column to its contents"},"selected":":count of :total selected","calculated":"Calculated value","layoutInvalid":"This file is not a layout saved from a pivot."}}
Too many cells to show at once. Some headers are left out; the totals still include them. Open fewer headers or limit a dimension.
Filters

Rows

Columns

Values

Fields

No records
Actions
Open