Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Can subtotal formula reflect filtered view?

Completed
Request Demo
Related to SUBTOTAL

I have applied a filter to my data, and I am using a =SUBTOTAL(9,...) formula, but all values in the range are included, instead of just the visible values of my filtered data. Is there a better way to do this?

1

Comments

2 comments

Date Votes
  • Mike
    • Edited

    Hello and welcome to the Community, Rory!

    Thanks for the question. If you are looking for the SUBTOTAL(109, RANGE) function to omit hidden values in your summation is not currently supported in Workiva. This is also mentioned here, and the good news is this is on the product roadmap to be added. I am definitely happy to add you as a requestor there as well.

    I should mention that the function only the SUBTOTAL 100+ ranges are not supported, but other SUBTOTAL functions are.

    Let me know if I've missed the mark, or you have any questions for me on the above. Thanks and happy Thursday!

     

    0
  • Isabel Messore
    • Edited

    Great news! A recent release has added some upgrades to our SUBTOTAL formula, notably that it now supports the hidden ell operators 101 thru 111. By default, this functionality is enabled though there are some caveats (listed below). New files or embedded tables will automatically upgrade to this formula version and any existing files (including copies) will be automatically upgraded to this formula version. Should you run into any scenarios where your formula is impacted by this change and not yet upgraded, you can reach out to your CSM or our Support team and they can assist in getting those migrated.

    0

Please sign in to leave a comment.