SAS VA i want to have the sum of distinct value of a column

[ajulio4]

In my reporting, i have some variables.  i put table oject on my reporting with a column XX, and i wand to have anytime, the sum of the distinct value i have for my column in the table oject.

Can someone helpe me please ?

thks

[Huzaifa_SAS]

Hi @ajulio4,

We need a better understanding of what you want to do. Having sample data might help us to provide a better answer for you.

-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center

[ajulio4]

Hello,

Thks you for the reply.

On my dashbord i have crosstable with columns and line like this :

And i would like to have in avariable, the sum of the distinct values of my columns Taille totale du FS(Go)

[HunterT_SAS]

I can't be certain without better understanding your data but I suspect you'll need to use the AggregateTable function and create something like this (this is from Visual Analytics 2025.04 so may look a little different if you are on Viya 3.5):

AggregateTable(_Sum_, Table(_CountDistinct_, Fixed('Dir'n), 'Taille totale du FS(Go)'n))

If that's not getting you what you are wanting, could you provide some sample data and what kind of results you are expecting?