Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have pivot table. all is fine but at the top it is showing blank values count. How can i remove it. I tried supress null values but nothing works.
Thanks.
From-To is having null values...
You can add below in Script
IF NOT ISNULL([From-To], [From-To]) as [From-To]
or at the end of the script....
Where NOT ISNULL([From-To]);
in dimension
check supress null value
Right click on chart Fit coloumn to Data
Thanks I did it earlier but it's not working. Any help please?
Thanks. It's not working. Any help please?
From-To is having null values...
You can add below in Script
IF NOT ISNULL([From-To], [From-To]) as [From-To]
or at the end of the script....
Where NOT ISNULL([From-To]);
Can you share your app?
After Load statement put where clause
WHERE [From-to] <>' '
Hope this helps
Regards
Manideep
Hi Ameila ,
Have you tried "Suppress When the Value is Null" Option under Dimensions Tab ????
I know you have mentioned this option already in your post but same kind of option is present under Presentation Tab also I don't know which one you have already tried.
Thanks,
AS
Thanks.
Actually the columns from-To is alias column like below
What& ' To ' &Queue as [From-To],
So, how can I change this? Please help