community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Report output - Excel help

Meteor

Hi All,

 

I am fairly new to reporting tool within Alteryx and wondering if its even possible to produce an excel report as shown in my attached spread sheet from the sample data under the data tab. 

 

Sample Data

 

CategoryBandPeriodProfitDiscount
Cat1A31/01/2018100000
Cat1B31/01/2018-50000
Cat2A31/01/2018150000
Cat2B31/01/201820000

 

 

In actual data , I have close to 12 months worth of data with more than 2 measures  .

 

Excel Report that needs to be produced from the above sheet.

 

report.PNG

so along with individual category and bands , the report should also have Cat , band level and over all total! ( horizontal total and vertical total )

 

Regards,

Ramesh

Asteroid

Hi @ram_neel 

 

This is the closest I could get to.

 

Hope this helps!

 

Cheers!

Meteor

hey thanks heaps! this is quite useful :)

Highlighted
Asteroid

Great, it helped you!

Labels