Add Summary at the top/Above the header & Group specific columns & Give a name

Question

Hello everyone,

I am new to Alteryx & trying to figure out a way to replicate this. Any suggestions would be greatly appreciated!

Current report

Expected Output

1. Group Specific columns & Update a name

I want to add a row above the header to group specific columns

for eg :

Select 3 Columns - D PSAT base, D PSAT  D FACTOR

Merge the cells above these columns

Update the group name to D PSAT

2. Add summary above the header

I want to insert 3 rows above the merged headers and include a summary, as shown in pic(expected output)

These summary values represent the sum of specific rows.

For eg: 'D PSAT Base' Should display the sum of values from the range I21:I30

Appreciate your help..!

A1.png

Expected output.jpg

OTrieger · Accepted Answer

@Pooja 
When I see a specific format that the data needs to have, I normally will create a template of it and then with Blob Copy then template and fill it out with the new data.

Qiu · Accepted Answer

Agree with the Blob reporting approach.

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280