Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have below pivot table
Dimension1 | Dimension2 | Expression1 (Total) | Expression2 |
---|---|---|---|
Country | IND | 100000 | 129 |
AUS | 0 | 0 |
In this pivot table if both expression value is 0/NULL then it is not showing the whole row as below while I am not suppressing any zero/null values.
Dimension1 | Dimension2 | Expression1(Total) | Expression2 |
---|---|---|---|
Country | IND | 100000 | 129 |
Why is automatically suppressing the value. Is there any way to get the first one pivot table. as I don't want to suppress.
That's what i am presenting here. Please check those options. i think those options are not checked. May be share image from presentation tab
Suppress When value is null ticked option is available in Presentation tab.
OR
Check in expression?
I don't want to suppress any value. I am saying that pivot table is
automatically suppressing value if both expressions have zero/null values
as shown above. I don't want to suppress that.
On Tue, Aug 22, 2017 at 9:30 AM, Anil Babu Samineni <
That's what i am presenting here. Please check those options. i think those options are not checked. May be share image from presentation tab
I have checked both checkbox suppress zero/null values. Both are unchecked.
On Tue, Aug 22, 2017 at 9:46 AM, Anil Babu Samineni <
Could you post your sample qvw that shows the issue?
Yes, I agree with Tresesco.
But, For validation can you try with Dimensions "Show all values"
Thanks guys for your help. I found my mistake. There were if condition
applied in my expression. Now it is working fine.
On Tue, Aug 22, 2017 at 10:49 AM, Anil Babu Samineni <