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
Solved! Go to Solution.
And Thank you for marking my post as solution.
Happy to help 🙂 @SanjayVyas
Cheers and Happy Analyzing 😀
_
Sorry for spamming i have pasted the solution right after your response.