show all row in pivot table even if other dimension is limited

[#1]

hi,

i try to do something

i have data depends on 2 dimensions

Task	month	data
Task1	1	0
Task3	1	0
Task1	2	0
Task2	2	0
Task1	3	0
Task2	3	0
Task1	4	0
Task2	1	1
Task3	2	1
Task3	3	1
Task2	4	1
Task3	4	1

first case, i try to show all tasks for each month in pivot table even if datas for task1 is null for each month.

this case is my first pivot table

second case, i try to limit number of month shown but i would like see all tasks too.

this case is my second pivot table

[#2]

Hi,

Hope this helps

Regards!

[#3]

Thx Gabriela!!

i was checked "delete null value" 😕