Pivot table 'total' not working

jhstrange — Mon, 07 Oct 2019 19:58:21 GMT

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.

Re: Pivot table 'total' not working

Vegar — Tue, 08 Oct 2019 04:00:03 GMT

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?

topic Re: Pivot table 'total' not working in App Development

Pivot table 'total' not working

Re: Pivot table 'total' not working