Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Reporting Excel table as pivot

SanjayVyas
7 - Meteor

Hi Team, I wanted to create my Excel output same as pivot. I'm able to generate the output from Alteryx however, not able to format the same as Pivot. Which consists (Headers and Grand total in Blue and False breaks in Gray color along with grid). The main challenge I'm facing is Total of Rows coming on top when I sort them descending (as I want Real breaks to be appeared first then false and then Total). So, in nut-shell below are my issues:

1. Total of Rows (records) to be appeared at last (after Real Breaks, and False Breaks)

2. Headers and Grand Total in Blue color with False Break in Gray color to high-light

Attached is the screen for your reference. Thanks

12 REPLIES 12
atcodedog05
22 - Nova
22 - Nova

And Thank you for marking my post as solution.

 

Happy to help 🙂 @SanjayVyas 

 

Cheers and Happy Analyzing 😀

atcodedog05
22 - Nova
22 - Nova

_

atcodedog05
22 - Nova
22 - Nova

Sorry for spamming i have pasted the solution right after your response.

Labels