Total is not appearing in pivot/standard table

[Rid_Hagos]

Hi,

In my Analysis, column and row totals are not appearing in both table types: pivot and standard. The data type of the field I am hoping to calculate a total for is ‘integer.’ Not quite sure why the total is not showing. Your help would be much appreciated!

Here’s the pivot table:

This is a snapshot of a few of the field’s rows within the dataset (Note: not every row has a value, so I’m not sure if this is related to the issue at all.)

Thank you!

[Max]

I believe the null’s are issues.

Can you try making an ifelse

ifelse(isNull({Annual Value}),0,{Annual Value})

And then see if that works ^?

[Rid_Hagos]

Hey Max,

Thanks for your reply! The issue was with the naming of the field in the dataset. The field’s name was “$ Annual Value.” Once I changed this to “Annual Value,” column and row totals appeared in the pivot table. The dollar symbol was problematic.

[dipanshugarg]

Hi @Max ,

I have a similar problem where I am able to see the total of the rows but not the columns. I had some null’s in the table which I changed to 0 but still cannot see the total of columns. There are some negative values as well in the table. One of my field name starts with an ‘_’ and I am wondering if that is the problem. Please suggest.