Why do filters break when pivoting a view?


Why does pivoting a view cause filters to break? This has been a major pain point for our users- is it possible there is a good work around?

Thank you.


  • @tomgilbert

    Because of the way the filter is defined…If you have Accounts.Data > 0 as a filter and then re-pivot the view to put Customers in the row along with Accounts, then the filter needs to change because it is now looking at the combination of Customers and Accounts.