OLAP: show what is filtering the grid

Posted by: abellisomi on 24 March 2020, 7:32 am EST

  • Posted 24 March 2020, 7:32 am EST

    Is there an easy way to show what the grid is filtered by?

    Thank you
  • Replied 24 March 2020, 7:25 pm EST


    Do you wish to always show the filter icon on the column? Or if there some other setting/layout where you would want to show the field by which the grid is filtered.

  • Marked as Answer

    Replied 24 March 2020, 10:15 pm EST

    For our users it would be beneficial to always see what is the context of the data they are seeing, so they need a view of what Filters are applied at any point in time.
    I solved it by getting the list of active fields this way:

    var filtersList = OlapPage.OlapEngine.Fields.Select(GetFormattedFilter)
    .Where(fieldFilter => !string.IsNullOrEmpty(fieldFilter)).ToArray();

    and printing that out in a TextBlock.
    It would be nice to have something that does this out of the box!

  • Replied 25 March 2020, 6:52 pm EST


    I got it. Currently, there is no UI element that shows such information. So, I have forwarded your request to the concerned team and requested them to consider adding such functionality [ID: 427259].
    *Please note C1Olap is now in maintenance mode. So, the feature will be added to the FlexPivot, if the team finds it feasible.

    With regards,
  • Replied 25 March 2020, 10:16 pm EST

    that makes sense. We need to upgrade to the latest version soon anyways
  • Replied 25 March 2020, 10:32 pm EST

    Oh, an additional note on this one: it is important for the filter criteria to be included in the exported files XLS so the users can keep track of what the data was based on.
  • Replied 26 March 2020, 1:56 pm EST

    Okay, have added it to the request.

  • Replied 26 March 2020, 6:21 pm EST


    Just as an update, the team has considered the request for future but there is no ETA as such. It would be implemented once they find it feasible

Need extra support?

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

Learn More

Forum Channels