Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #3489330
exporting totals
Closed

Comments

  • Paul Sullivan started the conversation
    October 1, 2023 at 1:05am

    I have a table of company financial data (revenue, costs etc) which includes filters for industry sector, company size etc. The sum and average for each column is displayed at the bottom and this changes depending on how the filters are set.

    I'd like to export the sum, average etc but this isn't supported. I tried using the shortcode but this doesn't respond dynamically to the filters. 

    I tried using the Mysql sum function for each column (revenue, costs etc) but this doesn't work when I add filters.

    Is there any workaround I can try without manually cutting and pasting totals into a spreadsheet? Thanks for your help

    Paul


  •  1,847
    Miloš replied
    October 4, 2023 at 11:01am

    Hi Paul,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    If you wish to set the calculation Shortcode and to have it respond to filtering on the source Table,

    you will have to set the source Table on the same Page where you set these Calculation Shortcodes,

    in that case, it should follow the filtering on the Table when it happens on the same page.

    Let me know if you try that, how it works?

    -

    There can also be a workaround with CSS to hide the main content of the Table and just leave Filters with the Calculation Shortcodes on the Page if you wish to try a design like that, let me know.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables