PivotTables: Sorting by Values as Default

[FredFarfadoe]

I am working on a Pivot Table for a requested report. I wish to sort the table by the values in the pivot table (specifically a sum of an amount field), which I can do by clicking on the column heading no problem.

However, since this will be a frequently used report, I want to have the datapage default to sorting by this value. I cannot figure out how, and saw some similar threads but not with conclusions.

 

Any thoughts?

[CoopperBackpack]

Hello @FredFarfadoe,

I`ve already replied to a similar question in this post: https://forums.caspio.com/topic/18712-sort-by-pivot-table-calcualted-field-value-why-is-counting-field-occurrences-so-hard/

I also cannot find any workaround, since there is no sorting option on the Pivot table DataPage.

For example, on the Tabular Report DataPage, we can specify the default sort order for up to 4 fields. 

 

Maybe you want to add your suggestions here https://caspio.uservoice.com/forums/164206-caspio-bridge

[NailDyanC]

You may consider checking this article: https://howto.caspio.com/tech-tips-and-articles/apply-default-sorting-to-a-column-in-pivot-table-datapages/