i have this type of table
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
can you explain your question more clearly
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.
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.