Discussion
CVS
US
Last activity: 22 Apr 2015 18:52 EDT
Multiple Levels of aggregate Data
Hello,
I want to create a report to display "Cover details", grouped by "subcase ID" and the "average elapsed time" for each "Flow action" of the subcase (Displayed across columns).
Something like this.
CoverID CoverName CoverUser SubcaseID FA1AverageTime FA2AverageTime
1 Test1 User1 101 2.34 1.23
102 3.4 3.7
2 Test2 User1 103 2.34 1.23
104 3.14 3.7
The solution iseasy if everything is grouped, but the details at the cover(Cover ID, Cover Name etc..) are specific to each Cover not grouped. This is where its getting tricky.
I have created a sub report on Subcase, joining it with the History to compute the average time. But when I add this sub report in the Cover main report, the cover details are getting displayed duplicately for each of the sub case instance as shown below.
CoverID CoverName CoverUser SubcaseID FA1AverageTime FA2AverageTime
1 Test1 User1 101 2.34 1.23
1 Test1 User1 102 3.4 3.7
2 Test2 User1 103 2.34 1.23
2 Test2 User 2 104 3.14 3.7
Any solution?
Pradeep
Pegasystems Inc.
US
I'm not quite following your example. For CoverID 2, CoverName Test2, there is both a User1 value and a User2 value, but you want to display both as User1 in your target display at the top?
Assuming this is a typo, what you seem to be saying is that you have several Group By fields that can only have one value when you expand them, and so you do not want to display them with the expansion icon and subtotals at the subsidiary levels, nor do you want to display them without any expansion icons, where the values are repeated in each Group By column. Then the best I can suggest is in our custom Main report to display group headings with those Group By columns.