i am making a report in a straight table.In which i have taken date as dimension. And i am calculating count of id's which are active as expression.
i am getting the active id's as per the date against them. But actually i want active id as on the date in dimension field. so can someone provide some way to calculate the active id's, as on the date comming in my chart..thanks..
If I understand your requirement correctly you basically want to sum the previous date count of active ID's to calculate the as on date values. You can do this by using inter record functions like above etc in the front end or Peek or previous if you want to calculate it in the scripting level.
