filter by month

CommunityMember125605
CommunityMember125605
in Modeling

i have this type of table

timeapr1apr2ap3aprmay1・・・all period
lineitem1001101
filter by allperiod✔✔✔✔✔✔
filter by month✔✔✔✔  

 

if i use filter by allperiod = lineitem1[select:time.all periods],

i catch all data like not only apr data but also may date .

i want only apr data by day 

 

i want to catch lineitem>0 only and aprs alldata 

after filtering

apr1apr2apr3aprallperiod
00111

 

Tagged:

Answers

  • ArunManickam
    ArunManickam

    can you explain your question more clearly

  • Misbah
    Misbah

    @CommunityMember125605 

     

    If you got your query correctly,

     

    Create a System Module - Dimensioned by Time only and Create a Boolean Line Item and keep its summary as "All"

     

    And define your logic for April month or any month that you want to consider. 

    Once you have Boolean for your April Month then you pull values based on the above boolean line item.

     

    Once again if you feel that is not the requirement, kindly elaborate and paste a small excel mock up in the attachments.

     

    Thanks,

    Misbah

  • DavidSmith
    DavidSmith

    @CommunityMember125605 

    If you want to include the detailed members that are checked AND the Total, then set the summary option for the line item (to be used as a filter) to ANY.

    David

Categories