changing flat data to data grid

rrrggg20 — Mon, 28 Dec 2020 22:10:28 GMT

Hello everyone, I have a data format looking like this

Project, Project Phase, CostDate, Grouping, Cost, year

p1, Ph1, 1/1/2020, g1, 1000, 2020

p1 ,Ph2, 1/1/2020, g1, 2000, 2020

p1, Ph2, 2/1/2020, g1,3000, 2021

p1, Ph2, 3/1/2020, g2, 4000, 2021

what I am trying to get out is a grid like this

I can get it to put the cost in all the phases, but not able to only put it in the (X/X)/Y coordinate that it belongs

X = Group

other X = Phase

Y = the costs occurred in the given months of the year.

Not looking for a completed solution, but thoughts around how this can easily be done

Thanks

Re: changing flat data to data grid

QFabian — Tue, 29 Dec 2020 00:08:26 GMT

H i@rrrggg20, i recreate your data and made this little qvw, please check it.

it is just a pivot table suming Cost and the dimensions you need

The only thing i cant understand is if you want to create Ph3