Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
5 years ago

why sum up total missing for some columns

I have created a table, in the values fields are columns from a fact table.   For some reason, when I add some new columns to the table, the values didn't get summed up on the bottom.  both columns...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Please give more details with your expected output and enlarge your screenshot.

Jeanxyz's avatar
Jeanxyz
Power Participant
5 years ago

Hi, 

I am trying to create a 'pivot table' in PB will will automatically sum up a numeric field via the implicit measure.

 

However, it looks PB doesn't create an implicit measure for the field Subscription Deal Value (max 5 yr) (€). When I hoover over the field, it doesn't show the sum up calculation.

 

 

the field ILF/OTL seems to work normally, PB does the sum up automatically, so I don't need to create a sumup measure for it.

 

I don't understand why the implicit measure doesn't work for the first field. This is a numeric column in my fact table, the column is set up as 'whole number' , summarization formula is 'sum'. I don't see any error in the column, so I don't understand why implicit measure fails to work.