# (pivot) report on joined tables

**URL:** <https://forums.knack.com/t/pivot-report-on-joined-tables/7238>\
**Category:** Get Answers\
**Created:** [December 4, 2017, 7:45pm UTC](https://forums.knack.com/t/pivot-report-on-joined-tables/7238 "2017-12-04T19:45:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![CraigDebbo47854](https://avatars.discourse-cdn.com/v4/letter/c/df788c/32.png) [@CraigDebbo47854](https://forums.knack.com/u/CraigDebbo47854)\
**Post date:** [December 4, 2017, 7:45pm UTC](https://forums.knack.com/t/pivot-report-on-joined-tables/7238/1 "2017-12-04T19:45:24Z")

</div>

Using a variation of the 'job posting' template provided by Knack.

I'd like to create a pivot report showing count of (table.applications) by table.job.name.

That is, I want to show "how many applications do I have for each job".

I can't seem to do this. I can't create a join on two tables and then create a report on this join? Or I can't create a view and pivot on this view. I also can't add job.name to the application record when a new application record is created (not good database practice) so that I could then pivot applications by name.

It seems so close in the Table view of Jobs when I add a column of the related applications records. I can almost see the 'sum' function ... but it's not there.

Help, Thanks

---

<div class="post-metadata">

**Author:** ![CraigDebbo47854](https://avatars.discourse-cdn.com/v4/letter/c/df788c/32.png) [@CraigDebbo47854](https://forums.knack.com/u/CraigDebbo47854)\
**Post date:** [December 7, 2017, 10:23pm UTC](https://forums.knack.com/t/pivot-report-on-joined-tables/7238/2 "2017-12-07T22:23:30Z")

</div>

And seems you can create 'formulas' that will do a little of the pivot for you. So I add a formula to the job table to count the number of related application records. Perfect.

Learning a little bit each time. ... :)

---

<div class="post-metadata">

**Author:** ![CraigDebbo47854](https://avatars.discourse-cdn.com/v4/letter/c/df788c/32.png) [@CraigDebbo47854](https://forums.knack.com/u/CraigDebbo47854)\
**Post date:** [December 4, 2017, 9:47pm UTC](https://forums.knack.com/t/pivot-report-on-joined-tables/7238/3 "2017-12-04T21:47:59Z")

</div>

Wait, I just found where I can update an 'application' record with data from the connected job record. [Form Rules -\> Record Rules : set field to connected-field value.]. Not ideal but gets the job done.

A new view of the joined tables would be preferred.

Thanks