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

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1232 views
  • 0 likes
  • 3 in conversation