BookmarkSubscribeRSS Feed
ajulio4
Obsidian | Level 7

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

3 REPLIES 3
Huzaifa_SAS
SAS Employee

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
Obsidian | Level 7

Hello,

Thks you for the reply.

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

cpplanning.png

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

HunterT_SAS
SAS Employee

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? 




hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 1279 views
  • 0 likes
  • 3 in conversation