Sort Pivot Table

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:

  1. Have an export button to allow getting the data out
  2. 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

1 Like

Me again :flushed:

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).

I guess I could create a formula field to extract the year then filter by that but where possible I’m trying to keep tables to the minimum.

Thank you once again.

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 :smiling_face:

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 :rofl:

1 Like

Delighted to hear that @garyGHL - sorry we didn’t update this thread.

What format are you hoping for exactly?

1 Like

Not a problem @darragh.

Its not a deal breaker, just wondered if I could shorten the months to Jan 25, Feb25 etc. Honestly not a big one.

Again, thanks, this is gong to save me a lot of time (and row counts :smiling_face_with_tear:)

image

BTW: Is there a page where I can see what enhancements have been released?

Thanks for the suggestion! We’ll see if there’s anything we can do!

As for our updates, we update this Product Updates page every month or two, I suspect we’ll include this change in our upcoming update.

We release lots of small things each day, which makes it difficult to keep everyone up to date.