RowCount for different RowGroups

• Nerrischer

  Grasshopper

  Points: 12

  More actions

  October 19, 2023 at 8:02 am

  #4310956

  Hi,

  I am working on a report which shows the Data as follows:

  Project A

  1   Evaluation Harry

  2   Evaluation Peter

  3   Evaluation Nadja

  Project B

  4 Evaluation Harry

  5 Evaluation Nadja

  ......

  The goal is to get a second numbering for the Projects, so the report will look like this:

  1     Project A

  1   Evaluation Harry

  2   Evaluation Peter

  3   Evaluation Nadja

  2     Project B

  4 Evaluation Harry

  5 Evaluation Nadja

  ......

  I tried to put a field in every detail-data set which contains:

  =iif(Fields!ProjectName.Value <> Previous(Fields!ProjectName.Value),1,0)

  so I got an "1" in the first "evaluation" row of each project.

  Then I wanted to sum these field in the group-head (which contains the Project) but i got the error, that I could not use "Previous in an aggregate".

  Hope I could describe my problem so you can follow and maybe help.

  Thanks

  Harry Richter

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  October 20, 2023 at 8:10 am

  #4311636

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.