Grouping Column Name Kreporter

How To Make KReport Like This?

Manipulate
use customSQL to get weeks
group by created, user name, type
count the IDs

Presentation > Pivot Settings
user name for the rows
Date, type for Columns
ID for value
Check options show totals and show sums

I don’t have pivot plugin. How can i get this plugin?

Pivot table is part of KReporter PRO for which you need a license.
Plese use contact form under http://www.spicecrm.io/kreporter/ to get a quotation.