Creating PDF document with Total

Kallis

Hello Everyone

I want to create a PDF from the data below. This is from an Excel Pivot.

I have built a WF and grouped by Category

Below is the Input.

The output must contain one PDF per category. At the moment, the WF considers Health as one category and creates a PDF for that. It also considers Health Total as another category and creates one more PDF for that. 

Likewise, one for Data Digital and one for Data Digital PDF

So on and so forth.

Is there a way to prepare one PDF per category? I mean, Health and Health Total must be in one PDF. Same with the rest.

Input 

		Values
Category	Cost Center	Sum of Cost FTM	Sum of Markup @15%	Sum of Total Billing	Sum of CostUSD	Sum of MarkUp USD
Health	Cost Centre 1	100	100	100	100	100
Health	Cost Centre 1	100	100	100	100	100
Health	Cost Centre 1	100	100	100	100	100
Health	Cost Centre 1	100	100	100	100	100
health Total		400	400	400	400	400
Data Digital	Cost Centre 2	4556	4556	4556	4556	4556
Data Digital	Cost Centre 2	2345	2345	2345	2345	2345
Data Digital	Cost Centre 2	5433	5433	5433	5433	5433
Data Digital	Cost Centre 2	77665	77665	77665	77665	77665
Data Digital	Cost Centre 2	33445	33445	33445	33445	33445
Data Digital Total		123444	123444	123444	123444	123444
Hosted	Cost Centre 3	554545	554545	554545	554545	554545
Hosted	Cost Centre 3	3232	3232	3232	3232	3232
Hosted	Cost Centre 3	5656	5656	5656	5656	5656
Hosted	Cost Centre 3	2434	2434	2434	2434	2434
Hosted Total		565867	565867	565867	565867	565867

martinson

Hi @Kallis you can create a new column with the category key in. This can be done in the mulit-row formula. You can then group on the ID. This can then be removed at a later stage. Let me know if you have any other questions.

martinson

Bulien