Hidden columns also appearing with enable Total

General
#1

I am using Helical Insight version 5.2.1.

I have created a report in which I have used an ID field, did sorting on it and used “Fetch and Hide”. I have enabled the column total for a numeric column, applied sorting, and then used fetch and hide for another measure (referred : https://www.youtube.com/watch?v=abRqvUGzm0I) .
However, the hidden column is still showing in the three dots. How can I fix this? Refer to the below image, it only shows 2 fields in the report but in the Show Total, it is showing other hidden field also.

image

#2

Hello Yaja,

The column on which you have applied FETCH & HIDE, if you simply set it to DISCRETE, our application will recognize it as a Dimension and will not attempt to apply a SUM to it. Then it will not appear in the three dots. Refer to the below images of how to do the same.
So click on the column on which you have done Fetch & Hide.

image

Then select Discrete option. Now that will not appear like that.

image

Thank You,
Helical Insight Team.