How to hide the base column, when used to create a calculated column

Hi Surav,

There are a couple options that you can do here.

1. Restrict access to the original column by user:

2. Create your calculated field using freehand SQL. You will not even need to have the original column in the view with this approach, as the values are queried straight from the database.

Please let me know if either of these work for you.

Regards,

Nathan

Thanks Nathan for responding.

My requirement is count(order_number) but in freehand SQL builder aggregate functions are not allowed.

And even if I set the access level, it is still displaying in the left hand panel.

Thanks,

Saurav

Hi Saurav,

With you limit the access to a column, that column should not appear in the report builder. In the example below I have created a second column `Trend No (Sum)` from the original field Trend No. I then set the original `Trend No` to restricted and added no users to have access (any users you ahve here will be able to see the column). In the report builder you can see that this column is no longer available.

Can you please provide screenshots of how you have set this up?

Regards,

Nathan

Hi Surav,

I am going to set this ticket to closed for now, but if you are still running into problems, or if there is anything else I can do to help here, please just let me know and the case will be re-opened!

Regards,

Nathan