Aggregating Records into one row

[wonka1234]

Hi,

How can I aggregate my dataset so I only have two rows? 

There should be 2 rows, one for louis .75 hours and one for 2.5 hours 

thanks

[Luke_C · Accepted solution]

Hi @wonka1234 

To keep it dynamic, I transposed and re-cross tabbed the data

[wonka1234]

@Luke_C  thanks Luke, how can I further aggregate this into one row?

[Luke_C]

Hi @wonka1234 

Unselect planned hours in the grouping options of both tools and it should sum down to one row.