On table visual how do I turn off the sum for one column but not all columns?

[Anonymous]

I have a visualization that is a simple table. I want one column to sum (which it is correct) but the table is also summing a column that I do not want to sum. How do I turn off summation on one column but not all?

See screeh shot: green is good...red is sum I want to turn off

[amitchandak · Accepted solution]

@Anonymous 

Right click on the field name of the field in visualization pane and use no summarization or change its data type to text.

[Anonymous]

Yes, changing it to text worked, thanks!

[VasTg]

@Anonymous 

Try this..

Sales Document = IF(ISFILTERED(Load Date Adj col),your actual cal goes here, BLANK())

If it helps, mark it as a solution
Kudos are nice too