Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a Pivot Table in my attached QVW which shows count of sal for each name for the possible values of Country_Name field.
As per the requirement, the table should always show all values of name along with the Total at bottom.
When I select a Country_Name value for which "Sal" value is available, the table works fine. But, when a Country_Name value with no "Sal" is selected, the chart shows Null at the bottom of name column. It is understandable as we don't have any name for the selected Country_Name. But the user wants to see some label instead of the Null.
Please help. Thanks in advance.
Cheers,
Mahesh
See attached example
hi
have a look at the attach example