Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to execute a. pivot table and get results into %DeepSee.ResultSet passing. in filters

Question
Jenna Makin · Jan 10, 2023

How to execute a. pivot table and get results into %DeepSee.ResultSet passing. in filters

Hi

I have a pvot table defined. that generates a set of data.   I want. to. execute the pivot table programatically  which I believe involves using %DeepSee.ResultSet.  Does someone have an example showing how to apply filters to the results?

For. example

[DateTime of Filing].[Date].[Date Filed Year] = &[2023]

Thanks

#Analytics #InterSystems IRIS BI (DeepSee)
Product version: IRIS 2022.2

Source URL:https://community.intersystems.com/post/how-execute-pivot-table-and-get-results-deepseeresultset-passing-filters