Different calcul in one pivot table

[Lucas HILLORION]

Hello, I'm trying to display my global sum of story points, but also the detail of how many belong to my Implem team and Func Team.

I only manage to do so by doing 3 different pivot tables, with each one its own "search request".

Is there a way, to do only one Pivot table, filled with 3 differents calculations on 3 differents column ?

The search are as below : 
Total Load : Project = X and IssueType = Enabler and Sprint = "Sprint 1"
Implem : Project = X and IssueType = Enabler and Labels = Implem and Sprint = "Sprint 1"
Func : Project = X and IssueType = Enabler and Labels = Func and Sprint = "Sprint 1"

Thanks in advance,

[Stiltsoft support · Accepted solution]

Hi @Lucas HILLORION ,

You may try the Table Transformer macro to group your issues.

Here I have a table that shows me all the issues from the Project X:

And here is my SQL query:

SELECT T1.'Labels',
SUM(T1.'Story Points') AS 'Sum of Story Points'
FROM T1
WHERE T1.'Issue Type' IS "Enabler"
GROUP BY T1.'Labels'

You may also adjust this query for other conditions and aggregation purposes.

Additionally you may wrap this table in the Table Filter macro (directly on Server/Data Center or via the Table Toolbox on Cloud) to count totals.

Hope this helps your case.

[Lucas HILLORION]

Thank you very much for your answer