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

[Kallis]

Hi @martinson 

Would you mind sending the code?

[martinson]

@Kallis Here is the code to create an ID column. IIF(contains([Row-1:Category], "Total"), [Row-1:ID]+1, [Row-1:ID])

Put this in the multi-row formula tool and select create a new field and call it ID.

martinson

Bulien

[Kallis]

Thanks @martinson 

Let me try this

[Kallis]

Hi @martinson 

Kindly let me know where should I copy the IF statement within the Multi Row Formula tool. 

Mine is different from the screenshot above. I am sorry. I am new to Alteryx

Thanks

[martinson]

@Kallis you should paste it within the expression box. The multi-row formula is a difficult tool to get used to, included in the Advanced tool set, so it may take some time to become comfortable with. Let me know if there's anything else I can help with!

martinson

Bulien

Here is a link to the multi-row formula lesson if you want to learn more.

[Kallis]

Sorry @martinson 

I am unable to make it work. Thanks for your help though.