Removing totals from table visualization

[Newbie777]

Hi,

I'd like to remove totals from a table visualization, as I am using Year as a dimension and the total of the years do not represent anything.  Please could you let me know where in the properties I can untick totals for a table?  

[rubenmarin]

Hi, if it's a simple table you need to set the totals option to 'none' in every expression.

[Newbie777]

Hi Rubenmarin,

Thanks for your comment, but where in the properties pane I am supposed to see the totals option?  I'd appreciate it if you could let me know where I can disable it.  

[rubenmarin]

Hi, it should be in the Expenses measure, expand it and look for the totals options.

[Newbie777]

Thanks again, but I cannot see the totals option where I can disable it.  

First, I expended the Measures, and

went into Expression, and the default setting shows "No aggregation" and total tick-box being grayed out.  Where am I supposed to see the total option?  

[Vikash]

Hi,

Go to the Appearance tab and uncheck the Total (Auto) Option. see below-

VK

[Newbie777]

Hi, 

Thanks for your response, but how can I get to that screen print you have pasted?  In my application, those choices do not appear when I get into the properties pane.  

[Vikash]

Hi ,

Scroll to the below of the properties panel then you will be able to see the Appearance tab. Under this,  you will see the Total checkbox. see below-

[Newbie777]

Thanks again, but the thing is, with this table visualization, those choices do not appear.  Other chart visualizations show the selections of Data, Sorting, Add-ons, and Appearance options when I go into properties pane, but for this table visualization, the below is the first screen after going into the properties pane.  I tried to expand several options but I couldn't see what I was looking for.  Am I missing something?  

[Vikash · Accepted solution]

Hi,

Deselect the Chart Suggestion option. Then you will be able to see the Appearance tab.

VK