Reputation: 275
how to sort sum values in ascending or descending order using pivottabke.js, please give python example code thanks
pivot_ui(struct_mto[[structConfig['MR Category'].iloc[0],structConfig['TotalUSD'].iloc[0],structConfig['Qty'].iloc[0],structConfig['WeightKg'].iloc[0],'MTO Revision']], rows=[structConfig['MR Category'].iloc[0]],rowOrder=["value_z_to_a"],cols=['MTO Revision'],outfile_path=chartFile,aggregatorName=["Sum","Decending"],vals=[structConfig['TotalUSD'].iloc[0]],rendererName="Horizontal Stacked Bar Chart")
Upvotes: 0
Views: 131