CoreBOSBB
Report Pivot table - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Report Pivot table (/showthread.php?tid=1690)



Report Pivot table - rslemer - 01-28-2020

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?


RE: Report Pivot table - joebordes - 01-28-2020

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


RE: Report Pivot table - rslemer - 01-28-2020

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


RE: Report Pivot table - rslemer - 02-03-2020

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