Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In a pivot table I have I have three dimensions City, College, University and one expression Major. Everything fits fine except there rows for each parent dimension where one of the dimension(College) has blank or null. If supress null value is chosen for college dimension the blank or null field still remains.
Is there a condition I can use to remove such rows?
Thank you so much for your time!
Thank you all for such great help! Eventually this is what worked for me:
I used calculated dimension instead.
Here's my calculated dimension, the first dimension (please note that the field Table2.Name and Table3.Name is being used as second and third dimension.)
=IF(ISNULL(Table2.Name) AND ISNULL(Table3.Name),NULL(),Table1.Name)
After selecting "Suppress When Value is Null" for the first dimension, it removes all the rows where both the fields Table2.Name and Table3.Name is null.
Here you have some examples
pfa sample
Vikas
HI Enrique thanks a lot for such a quick help. But my use case is to hide those rows where one of the dimesion has no value in it. Can I write a conditional if statement somewhere in this pivot table that would say don't give me those rows where the column for dimension College(in above snapshot) has no value?
You can use this examples for your problem
You can see the actions on the buton and see the expression
Thanks to both of you for your help.
I used calculated dimension instead to remove such row where both the dimensions have null value but now i have a new issue.
Here's my calculated dimension, the first dimension (please note that the field Table2.Name and Table3.Name is being used as second and third dimension.)
=IF(ISNULL(Table2.Name) AND ISNULL(Table3.Name),NULL(),Table1.Name)
After selecting "Suppress When Value is Null" for the first dimension, it removes all the rows where both the fields Table2.Name and Table3.Name is null.
However, the problem is now I am unable to select the Table1.Name in the Pivot Chart.
If I use AGGR as following the rows where Table2.Name and Table3.Name are null reappears which is what I don't need either.
Aggr(IF(ISNULL(Table2.Name) AND ISNULL(table3.Name),NULL(),Table1.Name),Table1.Name)
Is there a workaround for this?
Hi ,
Can you share sample QVW of your issue.
Regards,
Chinna
Hi,
check the attached file and modify the expression according to your reqiurment
Thank you all for such great help! Eventually this is what worked for me:
I used calculated dimension instead.
Here's my calculated dimension, the first dimension (please note that the field Table2.Name and Table3.Name is being used as second and third dimension.)
=IF(ISNULL(Table2.Name) AND ISNULL(Table3.Name),NULL(),Table1.Name)
After selecting "Suppress When Value is Null" for the first dimension, it removes all the rows where both the fields Table2.Name and Table3.Name is null.
it is not working form me , i have same situation like u , i have tried your way ,