Can subtotal formula reflect filtered view?
완료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?
-
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
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댓글을 남기려면 로그인하세요.
댓글
댓글 2개