Total is not appearing in pivot/standard table

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:
Screenshot 2023-05-17 at 8.50.47 PM

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.)
Screenshot 2023-05-17 at 8.47.01 PM

Thank you!

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 ^?

2 Likes

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.