I have salesperson on multiple rows and would like to clean it up so the value of Salesperson is distinct.
Also, what is a great reference for writing QlikView expressions?
Would prefer this result:
Convert your chart to Pivot Table.
That does work... but I lose the subtotals on GL Credit / Debit Sales, Net Sales, and Percentages on the SalesPerson and the grand totals on the table. Do you have to manually calculate those in the Pivot?
Retrieving data ...