Repeating Rows in Pivot Table

[MZZH]

I am having repeated line items in my pivot table below (see picture) .. the correct format should be Balance Sheet items appearing under the Balance Sheet section and likewise for Income Statement. I am guessing it might be something wrong with how the data model and/or Fact Tables being set up (see second picture for the data model). Can anyone kindly advise what are the changes required to achieve the desired format please?

ffwqfq

[BA_Pete]

Hi @MZZH ,

The first thing I'd do is check that null values are null, rather than blank, in the source data.

If null values do not explicitly say 'null' in the value cell then you can either:

-1- Right-click on a blank value in your values column, select 'Replace value' and write 'null' in 'Replace With...'

-2- Filter out the rows which only have a blank value

The next thing would be to just filter the pivot table, where 'Value' <> BLANK() and <> null.

Pete

[MZZH]

Additonally, these are the simple dim tables: