Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?