I’ve realized a strange behavior in pivot tables I think might be a bug. I’m wondering if anyone has any insight on this …
If I have an indicator that has no data in it, I expect it to appear as blank in a pivot table. However once I add another indicator that has data for any given period, the first indicator appears as zero. The attached screen shots are of:
- TESTING_1_ZERO (an indicator that should be blank)
- TESTING_2_ZERO (another indicator that should be blank)
- TESTING_3_ZERO (an indicator that has data = 1)
Further, if I select the measure criteria in the table options to be >0, the table remains the same (with the zeros).
Why are these zeros appearing?