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.
