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
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
Can I add another feature request to Pivots, I know its annoying but the pivots are such a great addition to Noloco, with a few extras it would be such a timesaver.
Could we have a default date for the search filter? In my example below I could set the default date as this year to restrict whats shown on loading.
We like to have the option of showing the last 3 years data to allow the user to compare data, currently when it loads it displays 36 columns (12 months x 3 years).
Hey @darragh & team. I’ve just noticed the Pivot sort on the summary column has been added which really is helpful for us. I know we chatted about it for some time, but to see it is amazing.
Its even caching the sort order per user which is the cherry in top
Anyway, thank you for this, I can hopefully remove 40+ sql queries now and use the in built Pivots.
Now, if we can find a way to shorten the date format