Skip to Content
0
Feb 28, 2019 at 05:03 AM

SAP Analysis for EXCEL - Display Null Data

830 Views Last edit Feb 28, 2019 at 05:14 AM 2 rev

Hello,

In SAP analysis office (Excel)

Detail:

DataSource: Infocube xxx (Not Query)

Table: Crosstab Style (Product type in row / Month in column)

Measure: Quantity (Unit)

SAP Analysis office: version 2.5.300.76689

Excel: Office 365 Version 1901

Problem:

If i have A-Z product type (26 Product). It show only product type that have a value (Not null)

Any suggest for display all product type although they are null ?

PS. Sorry for my English.

Regards,

Weerasak

Attachments