Grouping in Cross Tab

[omkar.patange]

Hello,

I would like to merge 5 columns (Type, Type2, Type3, Type4, Type5 ) in one one column name type. But the value (sum Hours) should calculate in Date column if select a date range in the report.
So It suppose to look like.

Worked Performed Location PO# Type Date Date Date

Ecowaste 1511 Eco Water truck Sum(Value) Sum(Value) Sum(Value)
Rock Truck Sum(Value) Sum(Value) Sum(Value)
Dump Truck Sum(Value) Sum(Value) Sum(Value)

* Sum(Value) == Hours1 + Hours2 + Hours3 + Hours3 + Hours5

[Lech Kulikowski]

Hello,

Try to use one column with summary of these values in the Cross-Tab.

Thank you.

[omkar.patange]

Please find the attached copy of .mrt file.
I would like to merge 5 type columns in one column if the value is the same.
Eg. In the attached file need to get rid types2-5 and keep only Type

[Lech Kulikowski]

Hello,

Unfortunately, it is not possible for the Cross-Tab component.

Thank you.