Hello everyone, How can we resolve this issue and display all the values in the table? Thanks

[Naiii]

 

[TSBruce]

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.

[Madelyn_SAS]

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)? 

[Naiii]

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

[Madelyn_SAS]

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