Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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