Skip to main content

Qlik

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 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: 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
‎2010-08-23 06:44 AM

Group by Month

I do have sales numbers on year,month,salesperson.
I want a pivottable with year,month,salesperson and percentage of sales.

Percentage of sales would be calculated on total sales per YearMonth per sales/total sales per YearMonth

The pivottable will contain more than 1 year.

Can anyone help me with the formula to aggregate this in the right way?

628 Views
0 Likes
1 Reply
Not applicable
‎2010-08-23 07:06 AM
Author

aggr(sum(salesmonth),salesperson) / aggr(sum(salesmonth),company)?

289 Views