i have this type of table
| time | apr1 | apr2 | ap3 | apr | may1・・・ | all period |
| lineitem1 | 0 | 0 | 1 | 1 | 0 | 1 |
| 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
| apr1 | apr2 | apr3 | apr | allperiod |
| 0 | 0 | 1 | 1 | 1 |