10 Replies Latest reply on Aug 24, 2016 9:55 AM by Luciano Vasconcelos

# How to filter out Grand total results less than 2

Hello,

I want to only show records with a grand total of more than 1. How do I do that? I attached a screenshot of the view.

Thank you

• ###### 1. Re: How to filter out Grand total results less than 2

Hi.

Build a calculation:

Total(Countd(Employee)) > 1

Drag into filter card and set to true.

I think it works but if not i'll need a twbx file to work.

• ###### 2. Re: How to filter out Grand total results less than 2

Hi Luciano,

When I put in the formulae and when I filtered on 1 everything disappeared. Could you please take a look at my file, tab Repeat violators?

Thank you

• ###### 4. Re: How to filter out Grand total results less than 2

oh, ok:( I'm not sure what to do about it.

• ###### 5. Re: How to filter out Grand total results less than 2

I don't know if you can post this, but you are using TDS files.

Maybe you can build a local version replacing this one by a local tde file and save as twbx file.

• ###### 6. Re: How to filter out Grand total results less than 2

Hi,

You can create a table calculation like this :

{Fixed: True Data, Status Group, Employee email, Manager Email: CNTD(Employee)}

Put this on the filter and select >1 numbers as filter.

This should work.

• ###### 7. Re: How to filter out Grand total results less than 2

I believe it will not work because of Status Group.

• ###### 8. Re: How to filter out Grand total results less than 2

Then I think he can manually group by using calculation like below:

Calculation2:

IF Status >=1 and Status <4 then Group 1

ElseIf Status >=4 and <7 then Group 1

.

.

.

.

END

Then the calculation can be :

{Fixed: True Data, Calculation2, Employee email, Manager Email: CNTD(Employee)}

Do you think that would work Luciano ?

1 of 1 people found this helpful
• ###### 9. Re: How to filter out Grand total results less than 2

Thank you for the tips. I'm not a tech expert so I'm not sure how to convert the files formats, but I will try the formula above and see if it works.

Thank you

• ###### 10. Re: How to filter out Grand total results less than 2

Probably.

Sometimes we lost some things seeing just prints.