Hi all, I'm new to QlikSense and have had trouble working on a particular table. This would be used to determine team members and their individual sales value, in addition to the total sales from the team. Ideally, it would look like this:
TOTALS
1,000,000.00
Member A
250,000.00
Member B
250,000.00
Member C
400,000.00
Member D
100,000.00
I used the tutorials for aggregate tables and could not find any unique or special commands in the app. It was able to do this no problem. However, when I set Members as a dimension and Sales as a measure of summation, my output was:
TOTALS
1,000,000.00
Member A
1,000,000.00
Member B
1,000,000.00
Member C
1,000,000.00
Member D
1,000,000.00
I feel like a special expression is required, and I've tried one string;
=Sum({SalesRep = {'SalesRep'}}Sales)
I have undefined outputs and am browsing a variety of tutorials wherever I can find them to gain more understanding. If possible, how would I add more columns to the table so I can quantify additional metrics such as customers served or orders processed? Any leads or examples would be appreciated.
