Hi, is there an option to sort pivot tables on the summary column? On the screenshot below, we have the option to sort on the row values only, it would make more sense (for us at least) to sort the tables on values in the row summary.
Other nice to haves:
- Have an export button to allow getting the data out
- Limit (pagination) option
Additionally, in this image, the cases column counts how many cases each row has but the summary column just reports the column count (months in this example so always going to be 12). Shouldn’t it count the values instead?
Example: 1 + 10 + 10 + 20 = 41 but the pivot shows 4