Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have salesperson on multiple rows and would like to clean it up so the value of Salesperson is distinct.
Any suggestions?
Also, what is a great reference for writing QlikView expressions?
Thanks
Example:
Would prefer this result:
Hi,
Convert your chart to Pivot Table.
Regards,
Kaushik Solanki
Kaushik,
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?
Thank you