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

[Pooja]

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..!

[OTrieger · Accepted solution]

@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 solution]

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/...

[Pooja]

I Created a template & then used blob to paste the data to a specific range this is usefull.

Was wondering if there is a way in alteryx to build the whole template, something to explore but for now this suffice my requirement thank you for the input.