Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Report Pivot table
#1
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?
Ranieri
eCRM Web
Reply
#2
there is a post and video in the blog on how to do this, have you read that?
Joe
TSolucio
Reply
#3
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


Attached Files Image(s)
                   
Ranieri
eCRM Web
Reply
#4
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
Ranieri
eCRM Web
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)