Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have one table (T1) as below
System
Report 12a 12c 12f 12h
P 5 1 3 2
Q 2 4 5 1
R 3 2 2 4
Here we can notice columns 12b, 12d, 12e, 12g are missing. I want to display with 0 amount. I'm unable to insert QV file.
So if anybody can guide me.
Thanking you in advance
Are those values missing or null for the reports that are visible? May be try unchecking 'Suppress Zero Values' on the presentation tab and see if that helps
Are those values missing or null for the reports that are visible? May be try unchecking 'Suppress Zero Values' on the presentation tab and see if that helps
It's suppressing some other rows which already have zero/null amount
Not sure I understand your comment/question?
Let take this way
I have one table (T1) as below
System
Report 12a 12c 12f 12h
P 5 1 0 2
Q 0 0 0 0
R 3 2 0 4
- 0 0 0 0
In fact columns 12b, 12d, 12e, 12g are not exists at all, so I added through inline statement.
By this I am getting blank row at the end as above; now if I try to suppress It suppress all column and rows having null/zero values
Thanks
Try to 'Suppress When Value Is Null' on the dimensions tab for Report dimension