Report Pivot table

[rslemer]

Is possible I created a report as pivot table like as

I have field user in employes module
I plan related with a assigned to in payments

and listen in columns, sum of amount, cost and paid

I should started choose how module first? ( employee or payments ? )
First field aggregation is a user ( in employes ) and second is amount in payments ( sum )

but system not show anything in report

how I do wrong?

[joebordes]

there is a post and video in the blog on how to do this, have you read that?

[rslemer]

this --> https://blog.corebos.org/blog/reports03 ?

---

I need related a field user in employee with a assigned to in payments ( because my intention is a sum of payments group by users )

In employee have two fields, assigned to and user ( what is a correct for use, in this case? )

in payments i choose assigned to ( my intention is group by, not a created user, but a user is working with this payment )

I wish produce a sum for amount, cost and benefit, in columns, for each user in employee with payments, marked as paid, in this mouth, for example ...

---

result

[rslemer]

I see a documentation, but gif animation not easy for learning, because is not possible stop or returned to understand better ..

If I can suggest you, use another tool like a video ... in coreBOS channel is better for that

anyway, I will try to learned and do in my demo test

thanks