Hey everyone!

With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:

Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.

We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.

In the meantime, if you need help, feel free to:

https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos

https://www.youtube.com/@wpDataTables/videos

Thank you for being so understanding, and we hope you enjoy the long weekend! 

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,894
    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