Hi
I have created a straight table which looks like below
| Risk Id | Workstream | Workstream Id | KPI name |
| R004 | CM | 1 | 3 |
| R007 | CM | 1 | 3 |
| R027 | AR | 5 | 3 |
| R028 | AR | 5 | 3 |
| R030 | CM | 1 | 3 |
| R033 | CM | 1 | 3 |
| R034 | DA | 2 | 3 |
| R035 | DA | 2 | 3 |
In Workstream column I have a aggregation expression like
=IF(GetSelectedCount(Workstream)=0,
Aggr(only({$<[Workstream Id]={$(vCalc_StatusPack_DefaultWorkstreamID)},[KPI name]={3}, Date =,[M0 Finish Month]=>}[Workstream]),[Workstream],[Workstream Id],[Risk Id],[KPI name]),
Aggr(only({$<[KPI name]={3},Date =,[M0 Finish Month]=>}[Workstream]),[Workstream],[Workstream Id],[Risk Id],[KPI name]))
In the above expression I have added Date = , so that any selections on the Date filter does not affect the data displayed in the table. But this doesn't seem to work, the table becomes blank as soon as I filter on Date attribute.
I donot have Date attribute in the underlying data of the table I am trying to display in straight table. However it is part of another table in the underlying data model of my app. That is the reason I don't want any selections on date to effect my straight table.
Please help me with the expression.
