Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-09-14 12:12 AM

Totals based on another dimension problem

Hi,

I am creating a report that tracks our sales people KPI's and I am having trouble with the calculation of the New Customers and Customers Served.

We get New Customers and Total Customers from a different spreadsheet which is at a Store Number level and I want to give each Sales Person the total for that Store Number. e.g. if there are 27 new customers and 48 customers served for a customer and 2 sales people, they would both have 27 new customers and 48 customers served. SEE BELOW.

Presentation1.jpg

I used the formula sum(total <[Store Number]> NewCustomers) which works at a sales person level but the total for each Area Manager only shows the total of all Area Managers not just the total for that Area Manager. SEE IMAGE.

Can someone help modify this code.

Thanks

David

400 Views
0 Likes
0 Replies