Removing total from some columns in table visual with a visual filter

[Anonymous]

Hi All,

I have a table visual with a visual filter for zero suppression. Now I want to turn off the total for 2 out of 7 columns in my tables. I tried using ISFILTERED function but it doenst work if there is a visual level filter. Is there a way i can acheive both zero suppression and total removal from certain columns. Appreciate some help. Here is the sample data. Column2 should not be totalled and zero row should be suppressed.
Original data:

Column1	Column2	Column3
A	100	250
B	200	500
C	300	750
D	400	1000
E	0	0
Total	1000	2500

Desired output:

Column1	Column2	Column3
A	100	250
B	200	500
C	300	750
D	400	1000
Total		2500

[DataInsights · Accepted solution]

@Anonymous,

Try the following:

1. Go to Format —> Field formatting

2. Select the field

3. Set the Font color to white (set it even if it already displays white)

4. Toggle “Apply to values” off

5. Toggle “Apply to total” on

[Anonymous]

Although this was not I was not looking. But this works for me for now. Thanks for a simple solution.