Good day everyone, I hope someone can help me with this issue. I have looked at a few posts and I am not sure if I am missing the language used (terms) or something just doesn't work. I have cross tabs in several reports that that users need to export "Formatted Data" data from. I must restrict the option for "Detailed Data". I have read where you can use a post-aggregate filter such as frequency percent, but that will restrict my results and I am not sure how you do that since I attempted to do that as a test. I have also heard of applying a filter on a custom category which I have attempted repeatedly without success. Maybe I am misunderstanding the terms. Here is the scenario, I have a crosstab in a report that provides summary data. I need for users to be able to export that summary data, the "Formatted Data", but not be able to export the "Detailed Data" which would include information we do not want a user to access (personal IDs for example), and there are also many, many columns. There are other tabs in the report that use the personal ID values so I cannot exclude them. I did attempt to add a dummy ID and filter to exclude that, but that did not work either. I have attached a PDF of the crosstab. As you can probably tell, there is a lot of data "behind the scenes" that creates this information that we do not want to be available for export. I understand there may be reasons, but I am thinking this should be a really simple option or process. Thank you, Gary
... View more