1 of 1 people found this helpful
I'm having difficulty with this without resorting to changing everything to table calculations. You can achieve this easily with a dashboard, but don't know if that's acceptable.
Edit: Maybe I was over-complicating it.
How about a count distinct of
(if [CurrentYearSales]>0 then [PartnerID] end)
There is a discrepancy in numbers - I'm guessing because of negative numbers?
thanks for your reply, i'm new for tableau, can you please explain more detail about " can achieve this easily with a dashboard"?
You could have both tables shown on a dashboard with the filter for non-active only on one
thanks a lot! i have created two tables to show revenue growth and No of active partners separately, it works fine.