Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
jhstrange
Contributor II
Contributor II

Pivot table 'total' not working

clipboard_image_0.png

 

I have an if condition as part of a chart expression that will allocate numerical value 1 for a particular condition. 1482 under 09/24/2019 in the image has been allocated 1 based on the if chart expression written. Whereas, all entries under 10/02 date(10811482,11701169, etc.) have been allocated 1 based on the source data itself.

 

I see total or aggregate value beside 10/02 date, but a blank or '-' beside 09/24 date and other parent fields in the pivot table. My aim is to have data beside 09/24 date and no blanks.

Attached JPG image file for reference.  Please let me know if you need further information. Any help would be highly appreciated.

Thank you.

1 Reply
Vegar
MVP
MVP

What is your expression? My guess is the blank - occurs because you get a null() as the result for your expression. Most likely because you have more than one unique value in the underlying data. What are you expecting as a value for 9/24?