Hello,

I need to create a Pivot report that includes the items from various forms, I mean, let's say I have 4 forms:

One Called "Store" with 2 fields:

    -  Single Line -> called Ref

    -  Single Line -> called pants

Second called "Employee"

   -  Single Line -> called worker

Third called "Shifts"

    -  Single Line -> called hours

Fourth called "Company"

    -  Lookup field from the form Store -> called RefLookup (display the field "Ref")

    -  Lookup field from the form Employee -> called workerLookup (display the field "worker")

    -  Lookup field from the form Shifts -> called hoursLookup (display the field "hours")

What I need is to create a Pivot report based on the Store form that display a count summary from the pants field BUT based on the workerLookup field and the hoursLookup field. There is a relationship between the Store and the Company forms due to the RefLookup field but that doesn't do much when I try to create the pivot report.

Thanks a lot!