You are most likely running into a constraint and may need to increase some of these values. You can find documentation on this at https://sas.service-now.com/csm?id=kb_article_view&sysparm_article=KB0036315. If this article is not helpful, I would suggest opening a Technical Support case.
Besides reviewing what @TSBruce sent, I was wondering which version you are using, and how many rows you are expecting to display. Your table has only 2 categories and a measure. If you select the table and then look at the Options tab, do you see a value specified for Override system data limit? Are either of those categories stored as VARCHAR and/or are they very long (i.e., thousands of characters)?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
J'ai un tableau croisé ici, c'est un simple exemple. Le problème, c'est que lorsque j'ajoute un champ avec des valeurs distinctes (1 441 053), rien ne s'affiche et le message suivant apparaît : Aucune donnée n'apparaît car trop de valeurs ont été renvoyées par la requête. Filtrez vos données pour réduire le nombre de valeurs
Would you be willing to create a SAS Technical Support case for this so that we can help further? The best way is to log in with your customer profile and provide the necessary information such as site number, product, and version.
Customer Support Center
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.