This content has been marked as final.
Show 4 replies

1. Re: SUM IF Calculation
Sanjay Nimbark May 26, 2016 8:28 AM (in response to Renato Lyke)Hi
The simplest way bring Metric in filter self and select Closed
and bring number in label self to and you selection measure to sum , count, countd etc.
Regards,
Sanjay

2. Re: SUM IF Calculation
Sanjay Nimbark May 26, 2016 8:32 AM (in response to Sanjay Nimbark)Also you can use
LOD I am thinking you might have numbers of row bringing in tableau which might calculating sum value wrong
you can use Fixed {[Metric] : sum[numbers] } you can additional dimension and also add filter self with metric and select "Closed"
hope this will help.
Regards,
Sanjay

3. Re: SUM IF Calculation
Renato Lyke May 26, 2016 9:15 AM (in response to Renato Lyke)Thanks Sanjay. It the same columns i have other metrics which i need to use to calculate % using closed values. If i filter that i would not help me.
Regarding using Fixed {[Metric] : sum[numbers] } where could i add this.
Regards,
Renato.
