I've had great difficulty getting my report to provide a breakdown of totals by three fields, and calculate the final field. I can get a total count no problem, but several dead-ends and now I need a push in the right direction:
I have this:
Type Quality Size
20 A 22x22
20 A 22x22
20 A 33x33
20 A 22x22
25 A 22x22
26 A 22x22
26 Z 22x22
I need this:
Type Quality CombinedSize
20 A 1452sqft 3pc
20 A 1089sqft 1pc
25 A 484sqft 1pc
26 A 484sqft 1pc
26 Z 484sqft 1pc
I need the breakdown sorted by Type, then Quality then Size and then report the count for those items.
Any gentle nudges will be welcome.
Qino
I have this:
Type Quality Size
20 A 22x22
20 A 22x22
20 A 33x33
20 A 22x22
25 A 22x22
26 A 22x22
26 Z 22x22
I need this:
Type Quality CombinedSize
20 A 1452sqft 3pc
20 A 1089sqft 1pc
25 A 484sqft 1pc
26 A 484sqft 1pc
26 Z 484sqft 1pc
I need the breakdown sorted by Type, then Quality then Size and then report the count for those items.
Any gentle nudges will be welcome.
Qino