Report with multiple columns under same group header

[Former Member]

I want to prepare a report which looks like the following

from a database like

The way i aproach is i create a group header listing out the OBJNAME in specified order like"BSS1_LTA, BSS1_LTB..so on" Now i want to filter ou PHASE A , B,C winding temp in 3 columns from OBJID or OBJPATHNAME and display the maximum value in 3 colums.. I HAve tried placing different formulas at 3 columns , but i am not getting the expected results.. This is the sample report i have created.

this is athe sample formula I have written for LT _Voltage_Phase_A

if ("FACILITY_TRANSFORMER_2ND_PHASE_A_WINDING_TEMP" in {S2KVTQ_VTQTimeView.OBJPATHNAME}) then Maximum ({S2KVTQ_VTQTimeView.OBJVALUE},{S2KVTQ_VTQTimeView.OBJNAME})

Please Help me solve this issue

[Former Member]

Not familiar with your data, but I would group by seqNo. -suppress header

Then create formulas as below for each Phase and add to details, Suppress detail section

if {S2KVTQ_VTQTimeView.OBJPATHNAME} like

"*FACILITY_TRANSFORMER_2ND_PHASE_A_WINDING_TEMP*" then {S2KVTQ_VTQTimeView.OBJVALUE} else 0

Then add maximum summary to this formula in seqNo group footer.

Ian