Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
minalux
Contributor II
Contributor II

Dimension Columns in a pivot table: How to get totals and sort in a specific manner

In a pivot table report, I've set the book title in rows and used Author (dimension) as columns.

minalux_1-1698853360918.png

1. For each author column, I would like a total. 

2. To sort, I would like the column orders to be

- Hal Elrod
- ILPUS

then for the rest of the authors, I'd like them to be sorted alphabetically

 

How would I achieve this? 

Labels (2)
1 Reply
tabletuner
Creator III
Creator III

Hi, is your problem still present?