Search code examples
reporting-servicesssrs-2012ssrs-tablix

Showing the date sales were first above 0

I have an SSRS report that has sales by week with the start date of every week. I want to create a column that shows the date where the sales are first above zero to denote the week that store first started trading, such as: https://i.sstatic.net/bxoCE.jpg

Is this possible? Any help would be greatly appreciated.

Thank you Sam

Solution

  • You will make a group on StoreId.

    For the Site Open expression use Min function combined with and Iif that checks when sales value is above zero. The "StoreId" in the expression is the group name

    = Min(Iif(Fields!Sales.Value>0, Fields!StartDate.Value, Nothing), "StoreId")