topic Re: Prb with Extraction from Pivot table showing zero values in App Development

Prb with Extraction from Pivot table showing zero values

dora_boughzela — Thu, 30 May 2024 14:27:05 GMT

Hello,

I have created a pivot table.

I used 2 dimensions and one as row and the other one as column. I used my values as rows ( I used 7 measures).

With less measures, the extraction does not contain 0. With 7 measures, the extraction contains 0 for a specific measure.

Is there limitations. I tested with measures on columns, it is all OK. But the business need is to have measures on rows.

Could you please let me know if it is a limitation or a bug ?

Kind regards,

Dorra

Re: Prb with Extraction from Pivot table showing zero values

TauseefKhan — Sun, 02 Jun 2024 05:24:47 GMT

Hi @dora_boughzela,

When you are using multiple measures, ensure that the aggregation functions are correctly applied. If a measure is calculated based on other fields that may have null or zero values, it could result in zeroes in the pivot table.

Or

Check the pivot table properties and settings. There might be options to suppress zeroes or null values. Adjust these settings to see if it affect the output.

Re: Prb with Extraction from Pivot table showing zero values

dora_boughzela — Thu, 06 Jun 2024 12:12:42 GMT

Hello,

Thank you for your reply. I see zeros only when I do the extraction, not in the app. Which seems weird.

I checked the settings, it is all good.

KR,

Dorra