Solved: Data not rolling up

Anonymous · ‎09-27-2018

Hi,

I have two tables in my report.I created a simple table view of the data. For one of the tables the $$ amount gets rolled up but for another table it does not and shows me the normal data source view. Below is the screen shot. I want View 2.

ofirk · ‎09-27-2018

Hey,

Is it possible that the values in the Budget Plan column are not stored as numbers (possibly: the data type of the column is text)? In these cases there is no summarization. If so, you can change the data type in Modeling.

View solution in original post

ofirk · ‎09-27-2018

Hey,

Is it possible that the values in the Budget Plan column are not stored as numbers (possibly: the data type of the column is text)? In these cases there is no summarization. If so, you can change the data type in Modeling.