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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies