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.