Prb with Extraction from Pivot table showing zero values

[dora_boughzela]

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

[TauseefKhan]

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.

[dora_boughzela]

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