Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

sum column error

hi ,I need to sum all the values of one coloumn, but unfortunately it showing some syntax error? can someone have a look and let me know, how to fix this?     Regards, vinod  
Need Help
Show and Tell
vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

Anonymous

 

this may not work in my other situations, I created a new coloumn using the below

SummarisedAccountsector = SELECTCOLUMNS(Inbound,"Sector",Inbound[AccountSector],"USD",Inbound[TER_FYTD_USD])

But whats happening is, i have only 3 account sector (Technology, Media & entertainment and Telecom)

my main issue is its not grouping the sector and their respetive aggregate sums

 

see the table table below

SectorUSD
Technology400000
Technology400000
Technology400000
media & entertainment400000
media & entertainment400000
media & entertainment400000
telecom700000
telecom700000
telecom700000

 

Expected table

 

SectorUSD
Technology400000
media & entertainment5000000
telecom700000

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

How have you arrived at the numers in the Expected table - they are difinitely not additions.  Anyways, just drag Sector to the row labels of the Table visual and then write a simple SUM measure

 

=SUM(Data[USD])

 

Hope this helps.