Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am having raw data as below..
Feild1 | Feild2 | feild3 |
A | 10 | 20 |
B | 60 | 40 |
C | ||
D |
when i created the Pivot table, i can able to see only first two rows(A,B), remaining two rows are suppressed due to they are not containing values .
i want to see the C,D rows also if they do not have any values.
please help me on this.
Under Dimension Tab of Chart,
Dimension - > Uncheck Suppress when value is null and Check Show All Value
Hi Sowmya,
unselect "Suppress when value is null" for Field1 field from option from tab "Dimensions"
Best regards
Andrea
see the attachment
Hi Balraj,
thank you for the quick reply,
ya i have done that but still it is not showing te remaining rows.
it is showing the null values which are in A,B rows... not showing C,D rows..
any other help?
Hi,
Select Chart>>Properties>>Dimension>>Tick on "Show All Values" option.
and Deselect "Suppress When Value is NULL" option.
I think that should solve your problem.
Regards,
KC
Hi Anlon,
thank you for the quick reply,
ya i have done that already,but it is not showing the remaining rows.
it is showing the null values which are in A,B rows... not showing C,D rows..
like....
Feild1 | Feild2 | feild3 | feild4 | feild5 |
A | 10 | 20 | 10 | 0 |
B | 60 | 40 | 0 | 20 |
C | ||||
D | ||||
any other help?
find the attached file
Hi,
Select Chart >>Presentation >>Uncheck 'Suppress Zero-Value' Option.