It's all about the answers!

Ask a question

Report Builder 602/604 consolidating pick list choices into a summary.

Mahari Hill (4861161230) | asked Mar 14 '18, 8:17 a.m.
edited Mar 14 '18, 9:04 a.m.

Hello all,

If I have a field called Part, and the choices are:

Car - door (5 Work Items)
Car - seat (5 WIs)
Car - tire (5 WIs)
Truck - door (5 WIs)
Truck - tire (5 WIs)
Truck - seat (5 WIs)

and I want to create a report that shows:

                       High                Medium              Low            Total
Car                   3                        4                      8                15
Truck                2                        8                      5                15
Total                 5                       12                    13               30

Can I do this in 602 (I'll settle for 604 as we may soon upgrade). I can do a dashboard widget with each, but combining and separating the values seems to take it to Report Builder.

thanks for any assistance

2 answers

permanent link
Donald Nong (14.5k414) | answered Mar 15 '18, 3:40 a.m.

Does this post give you an idea?

Basically you map an existing value to a different one. For example, all values starting with "Car" will be mapped to "Car".

permanent link
Jackie Albert (1.6k14946) | answered Mar 15 '18, 10:20 a.m.

It looks like you're trying to build a crosstab, which isn't supported in Report Builder.   Add your vote here:

Your answer

Register or to post your answer.