Skip to main content

Hi All,

 

Please find attached workbook which has data and data output what i am looking for - please share your thoughts.

 

I wanted to show based on values and date start and end may be we can use min and max along with date value . and values before 0 we can say as suspand and after zero resume.

 

please help . attached data and work book

 

v2020.2

1 answer
  1. Sep 24, 2020, 1:19 PM

    Hi @pavan m​ 

    do you still need an answer on this - saw it in the unanswered queue

    not certain what suspend means - but if you just dont want to show values with 0 you can use a lookup filter

    lookup(SUM([Count]),0)<>0 placed on the filter shelf and set to True

     

    Hi @pavan m​ do you still need an answer on this - saw it in the unanswered queuenot certain what suspend means - but if you just dont want to show values with 0 you can use a lookup filterlookup(SUM(

    If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote. 

    Also please help use better track your reply by including a mention to the volunteer who provided the answer  – mine is   @[Jim Dehner]​ 

    Thank you.

    Jim

0/9000