Hello Experts,
Requirement:-
There r 5 SalesPerson
Each month top 3 salesperson names are varying acc to sales
Business needs a report having TABLE with dynamic dimension value acc to top 3 salesperson changing each month
Suppose Month = Dec
SalesTable:
Salesperson | Sales
A | 300
B | 200
C | 100
Total Top 3 | 600
D | 200
E | 200
Total | 1000
Suppose Month = Jan
SalesTable:
Salesperson | Sales
D | 300
E | 200
C | 100
Total Top 3 | 600
A | 200
B | 200
Total | 1000
I have tried with Dimension Limitations but cant achieved the required format. Please help experts
