help on hiding months with no allocated values in a matrix

[Islam]

Hello Everyone

i'm trying to create a matrix showing the Pouring Amount which represents Revenue and Total Expenses which is the sum of Expenses and Purchased materials 

so i created the following measures

Total Materials Amount:=SUMX('Total Amounts','Total Amounts'[Materials Amount])

Total Expenses Amount:=SUMX('Total Amounts','Total Amounts'[Expenses Amount])

Total Pouring Amount:=SUMX('Total Amounts','Total Amounts'[Pouring Amount])

Net Profit/Loss:=[Total Pouring Amount]-[Total Expenses]

and that's how i wanna show the pivot table

i have no values for January 2020 but there are values for January 2021 so when i filter to show just January 2021 (It's Called يناير) with years rows displayed i get the correct values for January 2021 but an empty month for 2020 with the sum of all 2020 values like following picture

I want to hide 2020 January with no values and also fix the grand total calculation

Any help would be highly appreciated

[Anonymous]

Hi @Islam ,

You can refer the content in the following links to achieve it about hiding the rows with empty values:

How can I hide a pivot table row without any data?

How to Prevent Empty Cells from Displaying in a Pivot Table

What's the grand total calculation problem? The grand total value is wrong or something else? Could you please provide some original data(exclude sensitive data) to explain it? Thank you.

Best Regards

[Islam]

Any help gentlemen ?!