Subtotals to remain when filtering

Posted by: craigreilly on 3 November 2022, 4:10 am EST

    • Post Options:
    • Link

    Posted 3 November 2022, 4:10 am EST

    Looking at some of the Demo’s and they have a subtotal that does not disappear when they filter the data. I’ve looked thru the code, and do not see how this is enabled.

    It is not a column footer, because it is not at the bottom of Spread, but at the bottom of the data. (after the last row).

    This is my only filter column:

    FpSpread_PO.Sheets(0).Columns(3).AllowAutoFilter = True

    The last row has a subtotal of the numbers in column 4.

    When I filter by column 3, I’d like to see my subtotal of the whole still. I’ve attached a screen shot of the demo I am looking at. I’m sure I am missing something simple. Oh, and still on v13.

    ok - it won’t let me add screenshot, it might be sp*m.

  • Posted 3 November 2022, 7:13 am EST - Updated 3 November 2022, 7:18 am EST

  • Posted 3 November 2022, 8:12 am EST

    Using “TABLES” is what seems to do this.

  • Posted 7 November 2022, 4:01 pm EST

    I also don’t show how it’s activated

    slope io

  • Posted 9 November 2022, 5:47 am EST

     Dim table As TableView = FpSpread_PO.Sheets(0).AddTable("PO", startrow, startcol, rowcount, colcount, TableStyle.TableStyleDark9)

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels