how to show missing nulls and zero values for all branches?

[#1]

Hi everyone i had report which consists of two products data and for those things i taken dimension as branch, and taken suppress nulls,etc in my pivot table report. the problem is for some branches i don't one product values but for other product i have, but the for two products on particular date it's showing those branches just because it's not there in one category products.

So, how can i display all branches and for missing products i need to show zero's, how can i do that?

[Chanty4u]

hi try dis,

) In Dimension make sure that suppress null values is unchecked for ur dimens.

2) try this expression - Alt(YourExpression,0)

3) In presentation tab uncheck Suppress zero value

and chk dis below link

How to create static dimension in pivot table