Forum Discussion

Gazsim44's avatar
Gazsim44
Icon for Helper III rankHelper III
6 years ago

Add Total to Column in ADDCOLUMNS Measure

Hi All, I have two measures created to show the Top 'N' and 'Others' in terms of highest profit but when added to my table neither column is able to produce a total for the column. Is it possible to ...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago

Gazsim44  can you try uploading the photo of table again, I can't see it.

 

What is the data type for the two measures? I haven't spent much time reading your full post to know if that's the problem, but that's one of the first things I'd check. 

Gazsim44's avatar
Gazsim44
Icon for Helper III rankHelper III
6 years ago

AllisonKennedyBoth are set to whole number so I would hope this shouldnt be an issue?

 

Attached a copy of the table again.